Attleborough
Registered user
I'm going to push my luck and ask if I could have some more help from the collective genius please?
I have two Excel sheets Calculations.xls & Archive.xls
Calculations has a sheet call Totals which uses an assortment of formula to calculate production results gathered from other sheets.
Archive.xls is just that. Each week a new sheet is added to Archive and the results from Calculations are copied to Archive.
I want to copy the results (but not the formula) using vba from Totals sheet in Calculations.xls to a new sheet in Archive.xls
In effect I'll be copying the whole sheet as history has shown that when I'm not around who ever stands in doesn't copy and paste all the cells we need (How hard is it to Copy & Paste FFS!!
)
Both sheets are in the same folder on a server.
In addition I'd like the vba to bring up an InputBox where the user defines the name of the new sheet which will be added to Archive.xls at the front of all the other sheets with the pasted data from Totals added at the same time.
I want to put the code behind a button on the Totals sheet in Calculations so when I see I have my weeks results, I can press the button and the information is pasted across after inputting the new sheet name.
Can anyone help me out please?
Thanks
A.
I have two Excel sheets Calculations.xls & Archive.xls
Calculations has a sheet call Totals which uses an assortment of formula to calculate production results gathered from other sheets.
Archive.xls is just that. Each week a new sheet is added to Archive and the results from Calculations are copied to Archive.
I want to copy the results (but not the formula) using vba from Totals sheet in Calculations.xls to a new sheet in Archive.xls
In effect I'll be copying the whole sheet as history has shown that when I'm not around who ever stands in doesn't copy and paste all the cells we need (How hard is it to Copy & Paste FFS!!
)Both sheets are in the same folder on a server.
In addition I'd like the vba to bring up an InputBox where the user defines the name of the new sheet which will be added to Archive.xls at the front of all the other sheets with the pasted data from Totals added at the same time.
I want to put the code behind a button on the Totals sheet in Calculations so when I see I have my weeks results, I can press the button and the information is pasted across after inputting the new sheet name.
Can anyone help me out please?
Thanks
A.
