PDA

View Full Version : How to create macro which will move data from one worksheet to other worksheet?



bunty
02-21-2012, 04:45 AM
Hello Everyone,

How to create macro which will move data from one worksheet to other worksheet which is available in different excel file...
Requirement
1. I want to create 3 command buttons (open, close and update).
2. I am going to filter the data based on the criteria. When I click on open button the filter data is available in the sheet will move to open worksheet of other excel file.
Here I have to move few columns from one excel file to other not all the . If any data available in the mapping column of the target sheet, it will over right.

Example:
Source file name ----test_data.xls
Target file name ---- abc_data.xls (which have 3 sheets—open, close and update)

In test_data.xls I have filter data based on open date column. Now I clicked open button.Now column sl_no data will paste to “sl.no” column of open sheet of abc_data.xls. like that.
Looking for your support and response....

Thanks...

raji2678
02-23-2012, 11:39 PM
You can copy the entire sheet. Try creating a macro and observe the generated code.