Copy Constants Only

K

Khalil Handal

Hi,
Need to copy all "values" or "constants" (not Formulas) from one sheet to
another sheet in a different workbook. I did the following:
Edit -->Go To then Special (from dialogue box) then "constants"
I see all the cells that I want are selected. Then I tried to use the copy
command but I got the error message: "that command cannot be used on a
multiple selection".
Any ideas is appretiated!
Khalil
 
B

Bernard Liengme

Here is a method that works,
Copy everything to the second sheet
Not use Edit | Go To | Special | Formulas and tap the Delete key
best wishes
 
Top