Molletica
11-19-2014, 09:38 PM
HI,
could you please help me with any possibilities of writing a Macro based on the below constraints.
1. I have 70 files with 5 tabs each ( all the 70 files have similar tabs).
2. I want the data from each tab of the multiple files to be copied into new file.
3. I have attached example file for your reference.
Example: file 1, to File 5 has tabs Out sourcing, software, ITO services, professional & perms.
i want to copy data from tab Out sourcing from all the files and past in tab out sourcing (master file) a separate file. similarly to the other tabs.
Additional note:
1. in the files apart from the data there is one pivot also available. i don't want to copy the Pivot.
2. I need to the data upto row contains word " don't delete" ( after this line no data will be entered.
3. This word has been updated between data and Pivot.
Thanks and regards,
M.Mahesh
could you please help me with any possibilities of writing a Macro based on the below constraints.
1. I have 70 files with 5 tabs each ( all the 70 files have similar tabs).
2. I want the data from each tab of the multiple files to be copied into new file.
3. I have attached example file for your reference.
Example: file 1, to File 5 has tabs Out sourcing, software, ITO services, professional & perms.
i want to copy data from tab Out sourcing from all the files and past in tab out sourcing (master file) a separate file. similarly to the other tabs.
Additional note:
1. in the files apart from the data there is one pivot also available. i don't want to copy the Pivot.
2. I need to the data upto row contains word " don't delete" ( after this line no data will be entered.
3. This word has been updated between data and Pivot.
Thanks and regards,
M.Mahesh