use a cell containing the name of a sheet as a sheet name in ...

B

Bill Nielsen

I am collating data from several sheets into one sheet in a workbook. All
the sheets have the same data structure. I would like to put the sheet names
in cells on the top sheet then reference this cell to build formula's to
bring the data from the lower sheets up. This way I can make the formula
with drag rather than hand entering them or editing them.
 

Ask a Question

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.

Ask a Question

Top