Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Does anyone know if it's possible to do this?
I need to create a spreadsheet to monitor/track the progress of a certain function. What I want to do is be able to enter the different amounts on one sheet each day & have it update a master sheet. For example, if I enterered information with todays day on Sheet 2, cell C1, I'd like that amount to show up on my Master/Summary sheet in cell C1. Then tomorrow, if I enter that days total into cell C2 on Sheet 2 (so I can track how much was done each day), I'd like it to overlap on my Master/Summary sheet in cell C1 to show the current days total without adding the two amounts. If the day after, I enter a total into cell C3 on Sheet 2, that's the amount I want to see on the Master/Summary sheet in cell C1...so on & so forth. Does anyone know if it is possible to set something (function or formula) up to do this? I would appreciate if it there is a way, if someone out there could help me. :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |