Pasting Values

[sammy2x]

Hi,

I have developed a quoting tool which creates an output sheet detailing
all the info, What I would like to be able to do is take a copy of this
and paste the values (and Format to a new workbook). I'm currently
doing this manually and I unsure how to automate it!

I have never used VB which I'm guessing is the only way of doing it, so
please be gentle!!

Thanks,


Sam.

 

[Dave Peterson]

Try recording a macro when you select that output sheet.
Then edit|move or copy sheet (select copy and copy to a new workbook)
Then select all the cells on that new sheet.
edit|copy
Edit|paste special|Values

I got something that looked like:

Option Explicit
Sub Macro1()
Sheets("Sheet2").Select
Sheets("Sheet2").Copy
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub