View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
buddyorliz
 
Posts: n/a
Default Can I copy Everything in a worksheet to a new sheet EXCEPT the te

I use the same worksheet month after month, however when I create a new month
sheet and copy and paste last months to it, I either have to paste All or
just formats, formulas or ... I have to manually delete All the text (and
sometimes there is Lots)
I cant just clear it because I loose all my formulas.

I have been doing this for all most two years, and I know there is a lot
easier way, but I haven't found it.

Thanks,