Hi,
I want to combine data from 38 sheets into 1 sheet, all in the same workbook named "combined" (which should be on sheet 43)
Before those sheets, I have the following which I don't want the data off:
- Control (sheet 1) (where I change the tab names for the whole document, also using the vba code - module 1: see below)
- Summary (sheet 42)
- Sizes - F (sheet 40)
- Sizes - M (sheet 41)
So I want the data to be taken from "sheet 2 to 39". Which all rows and coulombs are exactly the same
I tried the below code, but it didn't work, it takes the data of everything in the workbook
MODULE 1
Bookmarks