Export data from one .xls file to another .xls file?

[exceln00b]

How do I export data from one .xls file to another .xls file? For example, one sheet has all the data for patients, time of surgery, age, etc. We needed to export data to another excel file (a daily template) that does not disclose certain rows, columns, or cells of information, i.e. do not disclose age of patient, etc.

Bottom line is how to get certain rows, cells, or columns that you specify to show on another excel file, exported.

Thanks!

[Will Riley]

You could use ADO to import selected columns to the other file from the master file.

Here is an example

Remote transfer of data - XL to XL