Hi Experts,
I am looking for a macro that will do the things mentioned below
There are 3 files sample1.xls & Data Of Step1.xlsx & macro.xlsm
Macro will be placd in macro.xlsm & all files are located in different places so the path will be hardcoded in the macro, so i can change it as per my needs
Condition:
Copy all the data from sample1.xls of sheet1 & paste it to Data Of Step1.xlsx in first sheet(sheet name in both the files may be anything)
Note:There may be data in the first sheet of Data Of Step1.xlsx or it will be a blank sheet so paste the data below that data
Plz see the sample files with output
download link: Data Of Step1.xlsx
Sample1.xls
I am looking for a macro that will do the things mentioned below
There are 3 files sample1.xls & Data Of Step1.xlsx & macro.xlsm
Macro will be placd in macro.xlsm & all files are located in different places so the path will be hardcoded in the macro, so i can change it as per my needs
Condition:
Copy all the data from sample1.xls of sheet1 & paste it to Data Of Step1.xlsx in first sheet(sheet name in both the files may be anything)
Note:There may be data in the first sheet of Data Of Step1.xlsx or it will be a blank sheet so paste the data below that data
Plz see the sample files with output
download link: Data Of Step1.xlsx
Sample1.xls
Copy & paste of the data between files [SOLVED]
Hi Experts, I am looking for a macro that will do the things mentioned below There are 3 files sample1.xls & Data Of Step1.xlsx & macro.xlsm Macro will be placd in macro.xlsm & all files are located in different places so the path will be hardcoded in the macro, so i can change it as...
www.excelforum.com