| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell lookup
I create a monthly profit&loss file that after each month, I do a file SAVE
AS to create next months file copy, etc. In the file, a Profit & loss sheet refers back to the same month of last year. How do I create a reference so the when I create the SAVE AS file, it looks back at the same month. Right now, i have to go into each cell and change the file look back name... i.e.='\\easfs\MonthendCorp\2005\[043005.xls]ConsYTD'!$B$6 How do I have the [043005.xls] change to [053105.xls] when I create the new file? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| How can I lookup a cell that's to the left? | Excel Discussion (Misc queries) | |||
| VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
| Return cell reference of lookup value | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
