Copying a Sheet in a Workbook to Another with Destination-Need Values Instead of Formulas

jeffreybrown · #1 08-19-2018, 06:55 AM

When pasting values only, you need to use two lines in the macro...

Code:

Sub ValuesOnly()
    Workbooks("050 FY 2019 Expenses-SSE.xlsx").Sheets("Excel Sum-Reforecast-FY 18").Range("A4:A98").Copy
    Workbooks("FY 18-SSE Actuals Plus Reforecast Budget.xlsx").Sheets("050-REVENUE").Range("A4:A98").PasteSpecial xlPasteValues
End Sub

https://www.thespreadsheetguru.com/t...-only-with-vba

rsrasc · #2 08-19-2018, 07:50 AM

Quote:

Originally Posted by jeffreybrown

When pasting values only, you need to use two lines in the macro...

Code:

Sub ValuesOnly()
    Workbooks("050 FY 2019 Expenses-SSE.xlsx").Sheets("Excel Sum-Reforecast-FY 18").Range("A4:A98").Copy
    Workbooks("FY 18-SSE Actuals Plus Reforecast Budget.xlsx").Sheets("050-REVENUE").Range("A4:A98").PasteSpecial xlPasteValues
End Sub

https://www.thespreadsheetguru.com/t...-only-with-vba

Hi Jeffrey,

Thank you for the code, and is working great.

Much appreciated.

Cheers!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying formulas	otuatail	Excel	3	06-03-2017 05:20 AM
Copying Every Other Row from one workbook to another.	eleno5485	Excel	1	04-07-2017 03:30 PM
Can a Data Source be one sheet in a multi-sheet Workbook	nfotx	Mail Merge	1	07-01-2015 12:55 AM
large workbook needs restarted every month with deletions and resort without losing formulas	llhail	Excel Programming	1	06-02-2015 05:34 PM
Adding rows and copying formulas	ejtoll	Word Tables	1	12-05-2012 05:09 PM