Help please with copy of sheet

Posted by Ken on October 31, 2001 2:56 PM

I just need some way of making Sheet1 equal to Sheet2 whenever data is added to Sheet1. So Sheet2 whenever it is selected will be identical to Sheet 1. I'll take a macro or anything else.

Thanks
Ken

Posted by Qroozn on October 31, 2001 3:10 PM

why dont't you just replace the formuals on sheet1 to =sheet1!a1 for all the cells.

Posted by Qrozzn on October 31, 2001 3:49 PM