Help copy data from .xls to a new .xls

Closed
baml - Jun 18, 2010 at 04:50 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 18, 2010 at 05:23 AM
Hello,

Hope someone can help me on the macro script to copy data from one .xls sheet to another .xls sheet.

column_1 column 2 column3 column 4


need help to copy all data in column 1 and column 3 to a new .xls file.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 18, 2010 at 05:23 AM
Are you going to replace whole column A, B and C in the other sheet ?

If yes, have you try to do it manually and record your action via macro recorder.

Even if the answer is no, macro recorder can give you a good template that you can make more generic for your requirement
1