Thread: [Solved] Copying a Sheet in a Workbook to Another with Destination-Need Values Instead of Formulas
View Single Post
 
Old 08-19-2018, 03:11 AM
rsrasc rsrasc is offline Windows 10 Office 2013
Competent Performer
  
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Copying a Sheet in a Workbook to Another with Destination-Need Values Instead of Formulas
Hi all,

I'm using the following macro to copy information from one workbook to another workbook.

Code:
Workbooks("050 FY 2019 Expenses-SSE.xlsx").Sheets("Excel Sum-Reforecast-FY 18").Range("A4:A98").Copy Destination:=Workbooks("FY 18-SSE Actuals Plus Reforecast Budget.xlsx").Sheets("050-REVENUE").Range("A4:A98")
The macro is working but the source file "050 FY 2019...." in column A has only formulas which are being copy to the destination file also as formulas.

I want the macro to copy the values only instead of the formulas. I have search a lot of pages but have not been able to find a solution.

As always your help is appreciated.
Reply With Quote