Me again ... Probably a very noob question ...
I have a workbook with 150 Sheets (Workbook 1). Every sheet is a location ("Rome", "London", ...).
I have another workbook (Workbook 2) that has exactly the same sheets ("Rome", "London", ...).
I would like to copy the value of range C8:C16 from Workbook1.Rome to range C8:C16 Workbook2.Rome and I want to do that for all sheets. Not sure if it helps, but the SheetName is also present in Cell (A1) of every sheet.
I know I can write a macro that cycles through the Sheets and copy/pastes in to the other sheet. However, I think that slows down everything. Is there an easier solution to that ?
Small side-note : there are also sheets that are subtotals, I don't want to copy those. I only want to copy those ranges where there is the word "Data" in cells (O1") of every sheet [I have written Data or Subtotal in those sheets].
I have a workbook with 150 Sheets (Workbook 1). Every sheet is a location ("Rome", "London", ...).
I have another workbook (Workbook 2) that has exactly the same sheets ("Rome", "London", ...).
I would like to copy the value of range C8:C16 from Workbook1.Rome to range C8:C16 Workbook2.Rome and I want to do that for all sheets. Not sure if it helps, but the SheetName is also present in Cell (A1) of every sheet.
I know I can write a macro that cycles through the Sheets and copy/pastes in to the other sheet. However, I think that slows down everything. Is there an easier solution to that ?
Small side-note : there are also sheets that are subtotals, I don't want to copy those. I only want to copy those ranges where there is the word "Data" in cells (O1") of every sheet [I have written Data or Subtotal in those sheets].