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

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Copying a Sheet in a Workbook to Another with Destination-Need Values Instead of Formulas

FAQ

Thread Tools

Display Modes

08-19-2018, 04:00 PM

p45cal

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

Office 2016

Expert

Join Date: Apr 2014

Posts: 956

There is a one liner:

Code:

Workbooks("FY 18-SSE Actuals Plus Reforecast Budget.xlsx").Sheets("050-REVENUE").Range("A4:A98").Value = Workbooks("050 FY 2019 Expenses-SSE.xlsx").Sheets("Excel Sum-Reforecast-FY 18").Range("A4:A98").Value

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:19 AM.