LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
buddyorliz
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how Excel can copy the data in a row of worksheet to other? CYCLERC Excel Worksheet Functions 0 January 16th 06 05:50 AM
Formula to copy text from a column in different workshhets TheTomo Excel Worksheet Functions 2 January 13th 06 04:09 PM
Copy worksheet & maintain cell reference across worksheets dingy101 Excel Worksheet Functions 3 January 2nd 06 10:51 AM
Is there a function to copy an entire worksheet? nickclingan Excel Worksheet Functions 3 December 23rd 05 03:23 PM
Copy answer to another worksheet mjohnson0321 Excel Discussion (Misc queries) 3 January 22nd 05 01:11 PM


All times are GMT +1. The time now is 05:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"