Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Excel Formulas

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
designci - 19 Apr 2008 22:23 GMT
I am trying to create a formula that averages numbers in a specific cells on
multiple worksheets within the same workbook.  Once I set up the template (or
Total page), I would like to be able to copy that page to another workbook
and have it function in the same way.  However, I am unable to get the
formulas to copy from one workbook to another without the reference to the
original workbook.  I am sure that there is a simple way of creating the
initial formula that would allow me to copy that worksheet from one workbook
to another, but keep the reference only to the workbook that is current.

This is taking hours to try to correct and figure out.  Help is appreciated!
Bill Kuunders - 19 Apr 2008 23:53 GMT
Two ways.

save the original first
Change all formula's to text by adding the ' at the front and change them
back to formula's in the new book.

Or
after copying and  moving the sheet use Edit > Replace to remove the
workbook name (replace with "").

Signature

Greetings from New Zealand

>I am trying to create a formula that averages numbers in a specific cells
>on
[quoted text clipped - 10 lines]
> This is taking hours to try to correct and figure out.  Help is
> appreciated!
Dave Peterson - 20 Apr 2008 00:03 GMT
I do this...

Select the worksheet to copy
Select all the cells on the worksheet and convert all the formulas to text.
I use:
Edit|replace
what:  =
with:  $$$$$=
replace all

Then I can copy the worksheet to the new location and reverse my actions (in
both the original and copied worksheet).

Edit|Replace
what:  $$$$$=
with:  =
replace all

> I am trying to create a formula that averages numbers in a specific cells on
> multiple worksheets within the same workbook.  Once I set up the template (or
[quoted text clipped - 6 lines]
>
> This is taking hours to try to correct and figure out.  Help is appreciated!

Signature

Dave Peterson


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.