I have a summary sheet which has a listing of all 75 worksheets within the workbook.
On each worksheet, I have a number, which is in the same location on each sheet (K2).
I want to use a formula to look at the value in column "A" (which is the name of the worksheet), and put the data in K2 from the worksheet it is referring to into column "B".
Sounds simple, but I've been banging my head against the wall for 3 hours trying to figure it out....
On each worksheet, I have a number, which is in the same location on each sheet (K2).
I want to use a formula to look at the value in column "A" (which is the name of the worksheet), and put the data in K2 from the worksheet it is referring to into column "B".
Sounds simple, but I've been banging my head against the wall for 3 hours trying to figure it out....