Hey folks,
I think I've seen this but can't find it...
I've got a table on sheet1 that has a list of names running from B2:B12. Each name has its own sheet with the same name.
I want to create a formula in C2 that allows me to copy down to C12 by going to the same cell on each sheet for each name.
I tried variations of =("'"&B2&"'"&"!"$E$22) but to no avail.
Thanks to whoever can come up with this.
I think I've seen this but can't find it...
I've got a table on sheet1 that has a list of names running from B2:B12. Each name has its own sheet with the same name.
I want to create a formula in C2 that allows me to copy down to C12 by going to the same cell on each sheet for each name.
I tried variations of =("'"&B2&"'"&"!"$E$22) but to no avail.
Thanks to whoever can come up with this.