Hi,
I run a project where i need to keep track of the cost during phases, but want to keep an overall cost of all the phases.
attached is a simplified version.
the workbook has three sheets: Phase one, Phase two, and total costs.

I would like to enter the costs items on either Phase one or Two and the have them appear on the total costs.

If i enter a costs into row 2 of "Phase one", It should appear on the total cost ledger as well, and in this case in row 2 of "total cost".

Then, i enter another costs into row 2 of "phase two" worksheet (it's first entry), that should appear on the first available line in the "total costs" worksheet.

that is my question: how to write a formula that copies a cell to the next available row, instead of a specific predetermined row.

Or any other workarounds on my set up could work.
thanks,


Rick

Attached Files

costs tracking sample.xlsx (11.3 KB, 10 views)