Any ideas if this is possible? example - imaginery syntax ;-)
vlookup(sheetname, A5:B5, 2)
Sho if the sheetname if 290 it will perform a V lookup for 290.
Thanks for thoughts
Any ideas if this is possible? example - imaginery syntax ;-)
vlookup(sheetname, A5:B5, 2)
Sho if the sheetname if 290 it will perform a V lookup for 290.
Thanks for thoughts
I'm a bit flaky on VBA but I think you ought to be able to set up a Worksheet Activate bit of VBA that stored the worksheet name in a cell which you can then easily reference in your vlookup.
Something like ...
Range("A1").Formula = ActiveSheet.Name
... would put the current worksheet name into cell A1.
Each time you returned to the worksheet, the cell would be updated but this is a tiny overhead.
Tony
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks