combine data entered on two worksheets to appear on a master worksheet
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
|