I have a summary sheet column of tab names for over 100 spreadsheets.
In the next column I need to reference a certain cell E2 in all of the
spreadsheets.
For example, for worksheet with tab name CAB I use =CAB!E2
Instead of manully editing each cell is there a way to reference the text in
the first column, e.g. CAB, to refer to the worksheet by that name in the
=CAB!E2 cell.
That way I only have to type in each worksheet name once in the first
column, and can save time editing numerous rows by dragging the series down
from the top row.
Thanks,
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
