Copy Values from WorkSheet back to Another Workbook Replacing Values in Worksheet

B

bobwilson

I want to copy values from ActiveSheet & Paste them back into my Master
Workbook (separate workbook). The Active Sheet above will have the same
Sheet Name in the Master Workbook that I want to copy values to.

In the Activesheet I have cell "C138" which has the name of the Master
Workbook.

This was my stab at coding it however it didn't work due the fact that
I'm so new to VB.

Dim activews As String ' ActiveSheet Name
Dim masterws As String ' Master Workbook Name

activews = ActiveSheet
masterws = Range("C138") '

ActiveSheet.Range("V48:V68,V73:V101,I72:I101,F105:G105,C106:D106,F106:G106,C107:G107,F108:G108,C109:D109,F109:G109,C110:G113,D128:G134,P110:Q110").Copy

Windows(masterws).Activate
Sheets(activews).Select
Range("V48:V68,V73:V101,I72:I101,F105:G105,C106:D106,F106:G106,C107:G107,F108:G108,C109:D109,F109:G109,C110:G113,D128:G134,P110:Q110").PasteSpecial
xlPasteValues
 
Top