Thread: get value from same cell on all sheets in a workbook.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GeneWan GeneWan is offline
external usenet poster
  
Posts: 21
Default get value from same cell on all sheets in a workbook.
I am trying to extract value from a particular cell, A4 from every sheet
(which are all name slightly differently) and tabulate on a summary sheet
(eg. "Sheet1"). Does anyone know how to do this efficiently?


Reply With QuoteReply With Quote