J
Jeff L
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)
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)