In an Excel spreadsheet is it possible (and if so, how) to copy data that are the results of a formula to another spreadsheet without bringing over all the raw data. I just get "#REF!" when trying to paste in the new spreadsheet obviously because I'm not also copying the source data... but I don't want the source data in the new spreadsheet. It this possible?
2007-09-19 17:29:14 · 5 answers · asked by tuoking 1 in Computers & Internet ➔ Software
Copy the data from the first spreadsheet, select the cell where you want to place the formula, right click on the cell, select "paste special" and then check "values" in drop down list.
OR - copy the data from the first spreadsheet, select the cell wher you want to place the formula, click "edit" on the toolbar at the top of the screen, select "paste special" from the drop down list, and then check "values" in the next drop down list.
2007-09-19 17:41:59 · answer #1 · answered by Anonymous · 5⤊ 0⤋
This Site Might Help You.
RE:
Excel question: how to copy data in cells derived from a formula to another spreasheet w/o copying raw data?
In an Excel spreadsheet is it possible (and if so, how) to copy data that are the results of a formula to another spreadsheet without bringing over all the raw data. I just get "#REF!" when trying to paste in the new spreadsheet obviously because I'm not also copying the source...
2015-08-10 02:53:24 · answer #2 · answered by Anonymous · 0⤊ 0⤋
as long as the sheet is open in another "page" of the workbook (at the bottom) you can do this. Wherever you want the data to match the numbers on your invoice use the formula =sheet1!A82 (wherever you want the information from A82 on the original sheet to copy to)... you will have to do this seperately for each cell that you want to copy as excel wont let you copy multiple cells as formulas however, as a time saver, you can always click the bottom right corner of the cell and drag it down, this will copy the cells in the consecutive order as they are listed the bright side is you only have to do this once! save it as a template and use it from now on :)
2016-03-13 06:25:53 · answer #3 · answered by Anonymous · 0⤊ 0⤋
I recommend using Paste Special just like the first answerer did, but instead of selecting Values select:
Values and number formats
If you select values, all it will copy are the raw values returned by the formulas. Then you will have to go back and reformat all of the cells that the numbers go into. If you do it by picking "Values and number formats" you shouldn't have to reformat the number values to look the same as they did in the original spreadsheet.
2007-09-21 04:51:15 · answer #4 · answered by devilishblueyes 7 · 1⤊ 1⤋
if you have a formula in sheet1 C1
goto sheet 2 g1 and enter this
=Sheet1!C1
you can also do this by going to sheet 2 G1 and hit = then goto sheet1 C1 and then hit enter
it will only show the value not the formula
2007-09-22 14:28:35 · answer #5 · answered by David M 6 · 1⤊ 0⤋