Thread: Take a value from several worksheets and put it in a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Take a value from several worksheets and put it in a column
List the sheet names that you want to take data from in column A of
your summary sheet, then use this formula in column B:

=INDIRECT("'"&A1&"'!B3")

Copy this down as required.

Hope this helps.

Pete

On Oct 7, 6:56*pm, pstepp wrote:
I have a work book with 74 worksheets. These sheets are arranged exactly the
same way so that all data has a particular address. I want to take cell B3
from all sheets and populate a column of the master worksheet. I want to do
this with several of the cells. What is the fastest way to do this?

Reply With QuoteReply With Quote