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

Can I copy everything EXCEPT text from one worksheet to another sh
 

I'd copy and paste just like you did.
Then with the pasted range still selected, you can hit:
edit|goto|special|click constants and ok
(notice the change in selection)
Then hit the delete key on the keyboard to clear those cells.



buddyorliz wrote:

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

--

Dave Peterson

Can I copy everything EXCEPT text from one worksheet to another sh
 

Once you have a blank sheet (with all the formulae on it) then rename
it as "Master". Then in future months when you want a new sheet just
copy the Master sheet by CTRL-drag and rename it to suit the month.
This will also have the advantage of retaining your column widths.

Hope this helps.

Pete

Can I copy everything EXCEPT text from one worksheet to another sh
 

Yes you can
you should select source and then destination worksheets (source worksheet MUST be on TOP) then select entire sheet or cells that you want to "copy"
and go to EDIT |FILL | ACCROSS worksheets and ir table select what you want to copy accross worksheets.

--
M.A.
"Pete_UK" wrote in message oups.com...

Once you have a blank sheet (with all the formulae on it) then rename
it as "Master". Then in future months when you want a new sheet just
copy the Master sheet by CTRL-drag and rename it to suit the month.
This will also have the advantage of retaining your column widths.

Hope this helps.

Pete