| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically change the worksheet reference when new sheet added
I maintain inventory on a spreadsheet. I am making a reference to a range of
cells. I add a new worksheet for each new day. I would like the reference to point to the last day added rather then what I do now which is point to a tab name then then rename it. Is there a way that references and external references to can change dynamically whenver a new sheet is added to the source workbook/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change a reference when the sheet change the folder? | Excel Worksheet Functions | |||
| Automatically change cell reference? | Excel Discussion (Misc queries) | |||
| Automatically change reference cell each month | Excel Discussion (Misc queries) | |||
| Automatically change tab reference | Excel Discussion (Misc queries) | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Threaded Mode
