Paste Special?

G

Guest

I want to copy data from a workbook to overwrite data on another workbook but
not to overwrite the formulas. The original worksheet will have either empty
cells or the value of 0 in the cells that contain the formula in the workbook
it is being pasted to. I can't find an option in Paste Special. Can anyone
help with this? Many thanks.
 
G

Guest

Yes, I had gathered that I couldn't use Paste Special, and I wondered if
there was another way of doing it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Special Values 2
Macro to copy & paste-special-values data to selected worksheets 1
Excel file size and paste special 11
Paste Values in linked Cells Only 4
Copying linked sheet 2
Special Pasting a work book with many sheets and formulas 2
copy and paste 4
Copy-Paste Chart into Word from Excel 2007 3

Top