getting cell values from multible sheets

  • Thread starter Thread starter bwcalvin
  • Start date Start date
B

bwcalvin

I have 100+ sheets in a workbook that I want to get a cell value (or
defined cell name) from each sheet and place them in one sheet. So, i
there was a cell named count1 for sheet one and count2 for sheet2 etc
I need to collect those names and place them on one sheet
 
Insert, Name, Paste, Paste list should do the trick.

Hope I understood your question properly.

Gilles
 
Back
Top