View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pstepp pstepp is offline
external usenet poster
 
Posts: 2
Default Take a value from several worksheets and put it in a column

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?