Hi
I have an excel document which is essentially one large action tracker.
Each 'tab' is as follows and represents the Master sheet (which should automatically have all data entered from the other sheets columns A-M inclusive) and then each other sheet is for each individual meeting.
I have designed it so columns A-M in each sheet are the same headers and will contain the same information - anything individual to a meeting which will not be on the master sheet is column M onwards.
The idea is that people can update their own actions in the individual sheets, and these will automatically transfer to the Master sheet for columns A-M only, from which I can collate data and see a master overview of everything.
My question is, how on earth do I get the data from each of the sheets to the master?!
Tab 1: "Master"
Tab 2: "Implementation"
Tab 3: "Validations"
Tab 4: "Governance"
Tab 5: "Line 2 and 3"
Tab 6: "Subcos"
I am Ok with pasting code into Visual Basic if required.
any help hugely appreciated!
Bookmarks