Lookup Same Cell over 31 WorkSheets in Same Workbook

  • Thread starter Thread starter Chicobo
  • Start date Start date
C

Chicobo

Hi there,

I have a workbook with 32 worksheets named from 'day 1' to 'da
31' and 'summary', all having the same format.
I would like to lookup for a cell value (G7) in every worksheet
to put in the 'summary' (F7:AJ7), day1 to day31.
How should I do this?


'Summary' same as
F7 G7 (Day1)
G7 G7 (Day2)
H7 G7 (Day3)


Thanks in advanc
 
Back
Top