Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

vba copy from one workbook to another workbook

0

I am trying to go to "richardson" workbook sheet BIKE INVENTORY and # BIKES BUIL  (with no T),    find last row of data, and copy the data (col A to H)  I get compile error on the fourth line  Workbooks("RICHARDSON.......

Workbooks("BEST_TEMPLATE_for_FINAL_REPORT_Ver_20_DATA_ALL_STORES.xlsm").Sheets("DATAEACHSTORE").Range("AZ6")

thanks  Carroll

[CODE]Private Sub CommandButton1_Click()
'RELOAD NEW DATA FOR EACH STORE FROM ASCEND QUERY REPORTS
Dim LROW As Long
'RELOAD NEW DATA RICHARDSON

Workbooks("RICHARDSON.xlsx").Sheets ("BIKE INVENTORY and # BIKES BUIL") '.Select
LROW = Range("A6").End(xlDown).Row
    MsgBox " RICHARDSON LROW = " & LROW

Workbooks("RICHARDSON.xlsx").Sheets("BIKE INVENTORY and # BIKES BUIL").Range("A2:H" & LROW).Copy

Workbooks("RICHARDSON.xlsx").Sheets("BIKE INVENTORY and # BIKES BUIL").Range("A2:H" & LROW).Copy .Workbooks("BEST_TEMPLATE_for_FINAL_REPORT_Ver_20_DATA_ALL_STORES.xlsm").Sheets("DATAEACHSTORE").Range("AZ6")


Exit SubCODE]

Answer
Discuss



Answer the Question

You must create an account to use the forum. Create an Account or Login