Hi Guys
I have 5 Excel workbooks having 3 sheets each.All book containing same format and sheet name.
I need to compile all the 5 sheets in one master sheet of all matching sheet names between master and source sheets.
All my source sheet is linked to another file, what i need in master sheet is only formats and values and not the formulas.
Ex; Source 1 sheet1 has rows 4 to 10, source 2 sheet 1 has rows 4 to 15.
Expected Result: master woprkbook sheet 1should have rows 4 to 10 from sheet 1 of source 1 and rows 11 to 25 from source 2 of sheet 1 and so on..
Is it possible?
Thanks for any help
Bookmarks