Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Every month I receive a new worksheet with that month's data. I have a master
sheet that I use to pull the data from this new worksheet. However, I have to go through all of the vlookup formula and change the referenced worksheet name. Is there a way to change the formula, so that it references a cell (A1) with the worksheet name? Example: =VLOOKUP(J$3,Q109!$U$6:$GM$20,$C12,FALSE) This is the formula everything is hooked up to, i.e. Q109 worksheet I then have to go through each formula and change it to Q209 worksheet. =VLOOKUP(J$3,Q209!$U$6:$GM$20,$C12,FALSE) Can I just have it reference a particular cell and when I change the name in the cell, all of the formula change which worksheet they reference? Thanks for you help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reference Data in 2 Worksheets | Excel Discussion (Misc queries) | |||
How to reference Worksheets in VBA properly | Excel Worksheet Functions | |||
Reference to worksheets | Excel Worksheet Functions | |||
Reference different worksheets | Excel Discussion (Misc queries) | |||
VLookup using 2 worksheets, whole column reference | Excel Worksheet Functions |