ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I move numbers with formulas behind to new workbook? (https://www.excelbanter.com/excel-worksheet-functions/186517-how-do-i-move-numbers-formulas-behind-new-workbook.html)

LINDA

How do I move numbers with formulas behind to new workbook?
 
I'm working with excel 2003. I received a spread sheet via email. There
are several colums adding up to a total. I want to do is take the total
column and the vendor name and move them to a new workbook. when I copy and
paste, the information will not transfer because of the related formulas.
Help Please

John Bundy

How do I move numbers with formulas behind to new workbook?
 
right click and select Paste Special, then select the Values box.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Linda" wrote:

I'm working with excel 2003. I received a spread sheet via email. There
are several colums adding up to a total. I want to do is take the total
column and the vendor name and move them to a new workbook. when I copy and
paste, the information will not transfer because of the related formulas.
Help Please



All times are GMT +1. The time now is 11:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com