Hello,
I am trying to copy across a reference for around 36 worksheets each titled: "Jan2011, Feb2011, Mar2011, Apr2011 etc. until Jan 2013"
I need to create a Masterlist worksheet for all the worksheets and I am unsure of how to copy the reference for the sheets across very quickly.
For example:
In my Mastersheet cell A1 I have the reference for worksheet "Jan2011"
=Jan2011!$A$27
In my cell B2 I have the reference for worksheet "Feb2011"
=Feb2011!$A$27
The position within the different worksheet doesnt change, but the worksheet changes 36 times for different months, and year.
Is there an easy way to copy across so in C1, and D1 and etc... It will form
=Mar2011!$A$27
=Apr2011!$A$27
etc?
Thanks!
Bookmarks