simpmark
07-11-2014, 03:42 PM
Hi,
I need to sum data from several sheets, where the values which should be returned variates. I have a "Total" sheet where I want to summerise forcast from different headers in every sheet in the file. The location of the forcast which should be retured to the sum sheet could be variating depending on how many accounts every header includes on the different sheets. What is consistent is the header which always start on A6 and the value that should be returned (forcast) always start in H6 in each sheet.
So for exampel "Staff" should be sumerised from all sheet "CC1000", "CC2000", "CC3000":s headers "Staff" into the sheet "Total", in D4. Likewise should all the other headers be summerised.
Could somebody please help me to find a VBA code in order to solve this?
I've attached an example, so you could understand my case.11931
Thanks!
I need to sum data from several sheets, where the values which should be returned variates. I have a "Total" sheet where I want to summerise forcast from different headers in every sheet in the file. The location of the forcast which should be retured to the sum sheet could be variating depending on how many accounts every header includes on the different sheets. What is consistent is the header which always start on A6 and the value that should be returned (forcast) always start in H6 in each sheet.
So for exampel "Staff" should be sumerised from all sheet "CC1000", "CC2000", "CC3000":s headers "Staff" into the sheet "Total", in D4. Likewise should all the other headers be summerised.
Could somebody please help me to find a VBA code in order to solve this?
I've attached an example, so you could understand my case.11931
Thanks!