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...
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...