I wish to have a workbook, that gets updated regularly with new data. I wish to ceate a totals sheet that has the ability to take data from a particular cell, in every sheet in the workbook.
All sheets are formated the same.
i.e. I want to add up all [A:1] cells in every sheet.
trouble is, the number of sheets grows on a daily basis. How do I formulate a variable to determined the number of sheets first? then add up the current amount of data in eash sheet? Is there a better approach?
Thanks in advance. I tried to do a search, but I am not exactly sure what syntax I should be looing for.
I am new to VB, so please explain in easy terminology.