Dynamic Link to various sheets

[Zafoid]

I have a spreadsheet that I use to calculate wages from timesheet values that I drop into a new sheet every week. (See attached Workbook). The first sheet is where I the wages calculation occurs which draws its Hours info from the sheets named Jan1, Jan2, etc. At the top of the WagesCalc sheet is a reference to the various time sheets, ordinarily I would use the VLOOKUP to match each employee to the previous weeks times however this only allows for one sheet at a time and I have to rewrite the VLOOKUP formula to link it to the other previous spreadsheets. Is there a way that I can dynamically link the sheets by just typing the sheet name (B1 on the WagesCalc sheet) so that the VLOOKUP formula changes when I change the reference to a sheet in B1?

[Pete_UK]

You can use this formula in D4:

=VLOOKUP(A4,INDIRECT("'"&$B$1&"'!$A$2:$G$5"),4,FALSE)

then when you change the tab name in cell B1 the formula will automatically adjust.

Hope this helps.

Pete

[Zafoid]

Yes that works well, Thanks :-))))

[Pete_UK]

You're welcome - glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete