Copy Constants Only

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
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
 
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
 
Back
Top