REF Error

[Chris Mcarthur]

On sheets 1 through 30 representing each day of the month I have data that I would like to transfer to the Summary sheet.
so for example I have '1'!A2 as a formula on the summary sheet and when i type it in, it seems to work but when I delete out all the data on sheet '1' and copy and paste the new information into when a new month begins, I get a REf error on my Summary sheet.why wont it pick up what is still in cell A2 on Sheet '1'?

 

[Chris Mcarthur]

Yes, It works great but one thing I actually noticed, if I want to save as say january, and then keep using the worksheet with the Macro for the next month, what is the best way to go about that?

 

[Joe4]

if I want to save as say january, and then keep using the worksheet with the Macro for the next month, what is the best way to go about that?

I am not sure what you mean. What behavior are you experiencing from the current macro that you would like to change?

 

[Chris Mcarthur]

hi I think its working ok now, so disregard my question please and thankyou again.