Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move data within workbook | Excel Discussion (Misc queries) | |||
automatically move cell data in 1 workbook to another workbook | Excel Worksheet Functions | |||
freezing formulas when cells move | Excel Worksheet Functions | |||
HelpNeed to know what formulas I need to use to move names in a co | Excel Worksheet Functions | |||
how can i move the starting point for the numbers numbers down. | Setting up and Configuration of Excel |