Dear experts, hope i can get the help!
I have a few reports to consolidate to the master report. All reports are in the same format as master file. i would like to copy the data from a few but not all worksheets of every report in one folder to the same named worksheets in master file. and the range in every sheets are different.
for eg. the data in worksheets "Leave" "OT" "Salary" from all files(only except master file) in folder "Pack" would need to be copied to sheets "Leave" "OT" "Salary" of master file respectively. Leave sheets 2,3,4 uncopied.
the copied data should be pasted below the data of the corresponding sheet in master file.
Also, how can i copy the file path and name of the workbooks where the copied data comes from to the column in master file?
in attached file the formulas are only picking up the data from sheet "Leave", how can i add the sheets "OT" and "Salary" in as well?
hope this makes sense. please let me know if not.
Bookmarks