I am trying to to create a sub total cell that adds the data of so many cells.
The problem happens when i want to add the values of the cells that are not there at the time of this formula.
This sounds complicated but all it is is two work sheets.
i have also created a macro which allows me to add the data to a cell in the second workbook.
I have created it so that it inserts a new row into the second workbook every time this macro is run.
So as you can see you cant actually set the sub total cell to add the cells i want as every time i run the macro it inserts a new row.
This means that new cells are created which the sub total cell does not understand
Sorry for the complicated story can anyone please help
Bookmarks