Hi,

I use a SaveAs feature for a report. there are 4 sheets in this work book in
total. The last 2 pages are summary sheets from the previous year. If i use
the following formula it changes the previous months data as I have changed
it in the Worksheet.

=Summary!C11 For Report March
=Summary!C11 For Report April

What would i enter to keep each cell using the data from the correct months
workbook. I use SaveAs the previous month and change the current data for the
current month.

Mar-10 2 1 50% $0 0
Apr-10 2 1 50% $0 0

I hope this explains what I am after.

Thanks for your help in advance.