Nethaji2509
New Member
- Joined
- Sep 27, 2016
- Messages
- 1
Hi friends.. am looking for assistance on a macro. I have three workbooks in the name of Data1,Data2 and Data3 which has details in 12 columns and saved in desktop. Also will have an excel workbook in the name of Template. I would want the macro to run from a template.xlsx. This will have two sheets first tab as Raw Data and second tab named as Required Data.
Now I need macro code that do the following in order.
1. Open Data1 and pull the details to Template Raw data tab and close the Data1.xlsx without saving and repeat the same with Data2 and Data3. This is basically consolidation of all the raw data.
2. In Required data tab there should be box in cell A2 where the user will key in a data say for example James and then they should run a macro which should go to Raw data and filter col.j and find for James and should copy the entire rows that contains James and paste to b1 of Required data.
Now I need macro code that do the following in order.
1. Open Data1 and pull the details to Template Raw data tab and close the Data1.xlsx without saving and repeat the same with Data2 and Data3. This is basically consolidation of all the raw data.
2. In Required data tab there should be box in cell A2 where the user will key in a data say for example James and then they should run a macro which should go to Raw data and filter col.j and find for James and should copy the entire rows that contains James and paste to b1 of Required data.
