| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Sheet
My boss fills out her timecards in Quattropro. She wants to do a running
tally of her vacation time so this requires Quattropro to look at the previous sheet and add a static number. The formula she currently uses in Quattropro is the following: @sum(010706:A22 + 4.46). 010706 is the sheet prior to the current sheet she is working on, 011406. When she copies this formula to the next sheet it changes to reference the sheet she is copying from. So if her next sheet is entitled 012106 the formula changes to @sum (011406:A22 + 4.46). Is this possible in Excel as we are transitioning completely to Excel from Quattropro. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| copying sheet references that refer to a cell in the preceding she | Excel Worksheet Functions | |||
| copying charts into new sheets, data is pulled from old sheet | Charts and Charting in Excel | |||
| Copying a total from another Sheet | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
