Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automating TAB names in calculations
I have an Excel 2003 workbook that I have set-up as a resource spreadsheet
currently with one resource. I am now trying to make it easier to add new resources. Each resource will have a task sheet and a holiday planner and I am trying to automate calculations using TAB names. Is there a way I can store a TAB name and then use this stored item so that when I add a new resource I can point calculations to the new tab name. I have a couple of examples of existing calculations below. If I add a new resource I will have to repoint all the calculations. =SUM(AbsencesJL!F:F) =VLOOKUP('Jeff Langdon'!H5,AbsencesJL!$E7:$I56,5) -- Thanks for your help Jeff L |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating Worksheet Names | Excel Worksheet Functions | |||
Semi-automating the generation of multiple cell range names | Excel Discussion (Misc queries) | |||
Automating Tab names | Excel Worksheet Functions | |||
Visual Basics - Automating Specific Sheet Names | Excel Discussion (Misc queries) | |||
Automating using VBA | Excel Worksheet Functions |