Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keeping a "floating cell"'s value
HI,
I have a log that lists jobs--their start and complete times. I want a total # of jobs started and completed. Not all jobs listed , start, and not all jobs listed, complete. That is no problem, i use the counta(). My problem comes in where the # of jobs listed can vary, so the cell that contains the "total" floats its row designation (it can be row 377 one day and 380 the next). That total is linked to another worksheet cell where it is totalled for the month. I keep having to go through and change the cell row number on both the original worksheet and the destination worksheet to keep the link working properly. I know its ounds confusing but i need the metrics for productivity sake. Please help.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keeping a "floating cell"'s value
Hi,
Use a dynamic named range. http://www.contextures.com/xlNames01.html#Dynamic This link provides good step by step Regards - Dave, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i save "floating cells" in an excel document?? | New Users to Excel | |||
Modifying a "Floating"(?) Cell | New Users to Excel | |||
Floating cell containing a "Running Total". | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
How do I create a "floating" header in Excel so I can always see i | Excel Discussion (Misc queries) |