Hello,
Currently I have a list of names on sheet 1. (named: names)
assume each name has a sheet that is named after it. (for the most part true)
I need to vlookup data that exists in each sheet (it moves around). I also have more then 500 names that change constantly so manually selecting the range would require to much time.
example:
Name: Number of reports:
Alex =vlookup("Report #", Alex!A1:D50,2,FALSE)
Ben =vlookup("Report #", Ben!A1:D50,2,FALSE)
John =vlookup("Report #", John!A1:D50,2,FALSE)
.
.
.
Forever (almost)
Basicially I need the sheet name in 2 to be = range("A2").value
I have tried multiple different things.
It seems that excel evaluates the "functions" in 2 and then wont ref that range.
Is this possible?
All help is great!
Thanks,
h55nick
Currently I have a list of names on sheet 1. (named: names)
assume each name has a sheet that is named after it. (for the most part true)
I need to vlookup data that exists in each sheet (it moves around). I also have more then 500 names that change constantly so manually selecting the range would require to much time.
example:
Name: Number of reports:
Alex =vlookup("Report #", Alex!A1:D50,2,FALSE)
Ben =vlookup("Report #", Ben!A1:D50,2,FALSE)
John =vlookup("Report #", John!A1:D50,2,FALSE)
.
.
.
Forever (almost)
Basicially I need the sheet name in 2 to be = range("A2").value
I have tried multiple different things.
It seems that excel evaluates the "functions" in 2 and then wont ref that range.
Is this possible?
All help is great!
Thanks,
h55nick