Q

C

C3

How to make a selected and copied worksheet (who has in cells some formulas
and for result some values) to a new worksheet to be filled only with
resulting values (without formulas)?
 
A

Alan

Highlight the whole sheet, Right Click, Copy
Select the cell in the new sheet that you want to paste,
Right Click, Paste Special, Formats, OK,
Right Click again, Paste Special, Values, OK,
Regards,
 

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

Drop down list control value in vba 2
VB Script reference cells for in current table? 1
Space at end of multi page list to accommodate new entries 1
Worksheet Names using Macros 5
MS Project. Real progress of the project, % complete 1
Copy the content of a cell with Formula 1
Getting text or numerical data from the formula 2
Autonumber field in Excel that behaves the same as Access 0

Top