LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Eric M
 
Posts: n/a
Default Office XP - Excel

I have constructed a worksheet (20,000 cells) and wish to copy the formulae
(but not the entries) into a new worksheet in the same workbook. How can I do
this?

Secondly, I then wish to change some of the formulae referring to the month
of March (MAR_05) to April (APR_05) so that the totals from the previous
months' workshhet can be brough forward to the new (April) worksheet. Rather
that do this on a cell by cell basis (about 90 cells) is there a way to do
this in one move?
 
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
ms office professional 2003 - Excel frustrated Excel Discussion (Misc queries) 2 March 2nd 05 10:33 AM
Need Office with Excel for windows 98 Green graduate student Excel Discussion (Misc queries) 2 February 14th 05 11:51 PM
Reinstall Excel 2002 after removing it during upgrade to Office 20 Bob Scullen Excel Discussion (Misc queries) 1 February 4th 05 09:12 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


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

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

About Us

"It's about Microsoft Excel"