Right now I have a copy worksheet macro. Works just fine for the most part, copies everything from sheet1 to sheet2 when I hit the macro button with the exception of one thing. One of my cells on sheet1 has a function that references worksheets. When sheet2 is created, the function no longer references the worksheets and is replaced by #REF.
Example:
on sheet1 I have this macro
=sum('sheet 1':'sheet 2'!A10)
when sheet2 is created, this function then reads as the following on sheet2
=sum(#REF:#REF!A10)
I want that function to read exactly the same as it does on sheet2 as it does on sheet1
Any help would be great! Thanks!
Example:
on sheet1 I have this macro
=sum('sheet 1':'sheet 2'!A10)
when sheet2 is created, this function then reads as the following on sheet2
=sum(#REF:#REF!A10)
I want that function to read exactly the same as it does on sheet2 as it does on sheet1
Any help would be great! Thanks!