Referring to other sheets within a workbook

  • Thread starter Thread starter Arsie
  • Start date Start date
A

Arsie

This is driving me barmy. Any help would be great.

I have list of formulae in cells a1:a50 in a sheet to pick up from specific
cells in other worksheets called week01 to week50

Something like this :---
Column A Column B
Row 1 Week01 week01!a1
Row 2 Week02 week02a1

etc

Is there a formula or function I can use in b1:b50 that will pick up the
words "Week01" etc and add that to the cell reference "a1" so that I don't
have to type every sheet name and the data appears automatically.


Hope this makes sense!


Thanks

Arsie
 
Back
Top