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