| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change formula file reference by changing value in cell
I have a workbook that has seven tabs for the days of the week and each sheet
is identical except for the date in A1. I have a number of cells on each sheet that are linked to another workbook to pull inventory information from it. File name example Inventory MM-DD-YY.xls Right now, in order to update the sheet on a weekly basis, I use find and replace to search for all instances of last weekending date and replace it with the current weekending date. What can I do to simply enter the new weekending date in a cell and all the formulas will change automatically? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy an exact formula without changing cell reference | Excel Worksheet Functions | |||
| Change of File name within a cell reference | Excel Discussion (Misc queries) | |||
| How to change reference to other worksheet by changing one cell? | Excel Worksheet Functions | |||
| A cell reference in a formula changing | Excel Worksheet Functions | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
Threaded Mode
