Thread: Collect data from spesific cell in multiple sheets
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
  
Posts: 376
Default Collect data from spesific cell in multiple sheets
hi Espen

On your Sum sheet, enter the list of your sheet names 01.01 to 31.12 in
cells A1:A365
In B1 enter
=INDIRECT("'" & A1 &"'!A1")
and copy down

--
Regards
Roger Govier

Espen Rostad wrote:
Thank you Mike, but I need all results in a row. Eg Sheet '1.1' cell A1 in
Sheet 'SUM' A1, Sheet '2.1' cell A1 in Sheet 'SUM' A2 .. and so on

Mike H skrev:
Reply With QuoteReply With Quote