| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying forward a number
Every day I do a reconciliation where I have to copy the figure from the
previous day's rec (B35), then subtract a figure from today's rec (B9) and add a figure from another cell also in today's rec (D9) to give me the new figure in B35. There are a number of worksheets and I have to do it for every worksheet. What formula could I use instead? My main confusion is that the previous day's file is saved with the format singaporeyymmdd.yyyymmddand then 6 digits. The first dd is the previous day |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying by Sequence Number | Excel Discussion (Misc queries) | |||
| formula for text and if correct bring forward a number | Excel Discussion (Misc queries) | |||
| The best way forward? | Excel Worksheet Functions | |||
| copying formulas forward and have the column refference move backw | Excel Worksheet Functions | |||
| Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
