Copy and Paste without copying Formulas

K

Ken

I have created a workbook with several sheets. The first
sheet consists of a master list of 8000 numbers. The
second sheet is where I paste a smaller list of numbers.
The workbook performs a search and returns numbers that
match on the third sheet. The third sheet also has
formulas. I want to be able to copy and paste the
resulting info on the third sheet to another workbook
without copying any of the formulas......I just want the
info. Any suggestions??
 

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

Top