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