#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summing data from multiple worksheets in a workbook and placing into another worksheet | safrac | Excel | 17 | 10-04-2022 12:21 PM |
Several Worksheets into one master | caz46 | Excel Programming | 2 | 05-11-2018 11:13 PM |
Master tab data list parsed out to applicable cells in applicable worksheets | kiwimtnbkr | Excel Programming | 11 | 10-28-2017 01:38 PM |
Combine values from different worksheets into a single worksheet. | jimmy2016 | Excel | 2 | 10-06-2016 09:15 AM |
Combine or merge multiple worksheets into one worksheet | timomaha | Excel | 1 | 07-21-2014 01:02 PM |