dngidotcom
New Member
- Joined
- Feb 16, 2002
- Messages
- 2
Hi. Hopefully this is simple, just not simple for me to figure out:
3 Worksheets: ws1, ws2, ws3 (acutually hundreds, but for simplicity...)
ws1 has a table that pulls values from the various other worksheets
ws1:
A1="ws2" B1=ws2!A1 < gets first cell value from ws2
A2="ws3" B2=ws3!A1 < same from worksheet ws3
...
A100="ws100" B100=ws100!A1
Basically I just need a formula in column B of ws1 that gets the worksheet names from the text in column A, the "wsX!" part, not the cell reference. The part after the "!" is all relative and copies fine. It is just the part before the "!", that tells the worksheet name.
I tried things like:
CONCATENATE(B1,"!","A1")
but that just returns text.
3 Worksheets: ws1, ws2, ws3 (acutually hundreds, but for simplicity...)
ws1 has a table that pulls values from the various other worksheets
ws1:
A1="ws2" B1=ws2!A1 < gets first cell value from ws2
A2="ws3" B2=ws3!A1 < same from worksheet ws3
...
A100="ws100" B100=ws100!A1
Basically I just need a formula in column B of ws1 that gets the worksheet names from the text in column A, the "wsX!" part, not the cell reference. The part after the "!" is all relative and copies fine. It is just the part before the "!", that tells the worksheet name.
I tried things like:
CONCATENATE(B1,"!","A1")
but that just returns text.