|What is the correct way to copy a whole sheet to another existing sheet in the same workbook?|
i would like sheet4 to store my data and copy it to sheet1 each time i run my macro, sheet1 being the sheet the macro does its work on.
every which way i have tried to do this it either doesnt work, or copies 1000s of columns of blanks and excel says it has no resources.
the macro is going to destroy the data on sheet1 when it runs, but i will need to repeat this proceses a few times to get my output data the way i want. so i need it to refresh sheet1 with the unadultered data each time i run the macro.