Creating a report with real numbers out of one with formulas

misterweber

New Member
Joined
Jan 15, 2004
Messages
13
Hi all! This is my first post, so I'm going to make it a good one... then again, you may say "this guy's not too sharp for asking such a simple question..." oh whatever, here goes.

This one was handed to me recently, and I'm baffled as to how to fix it. I have a scorecard report that I have to fill out daily. I have to move that information over to two other spreadsheets. I know how to link cells across files, but that causes a problem. The "other" sheets get sent by email to people and if the numbers are automated with a standard link (such as ='sheet1.xls'!C5), the product page produces a #REF! error if both files are not present.

The current solution has been to manually copy the information from 'sheet1.xls' to 'sheet2.xls' <s>and update the graphs</s> (not anymore, I fixed that problem real quick). Is there a way to migrate data into several files so that the cell contents are numbers (and not formulas) in both sheets?

I could really use the help. I'm at your mercy, oh gurus of excel!
:pray:
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,982
Office Version
  1. 365
Platform
  1. Windows
Re: Creating a report with real numbers out of one with form

Can you use Copy, then use the Paste Special | Vales option to convert all your formulas to values? If you just Paste over the original range, it essentially converts everything to values in the same place.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,047
Messages
5,639,766
Members
417,109
Latest member
996

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top