Can I copy everything EXCEPT text from one worksheet to another sh
I need to copy the formulas, format etc.. from one sheet to another sheet,
but I do not all the text (data I have put in for the previous month.
I have been, using copy and paste But then I'm having to clear Each cell
that is used to do all the calculations (sometimes there are over 200).
I do not use any calculations based on previous sheets (as far as like
adding something from one page to another for totals)
Just want to use that one sheet - blank - to start my new month.
Thanks to anyone that can make this easier for me.
Liz
|