sorry i am not experienced in VBA. I have 2 workbooks (saleman .xls and DailyReport.xlsm). Saleman .xls is generated by my POS daily by over writing the existing data in the file. DailyReport.xlsm has functions to generate reports using data copied from saleman .xls. I am trying make a vba script that will copy data from saleman .xls ( excluding headings) and paste to the last row of the table in sheet 1 of DailyReport.xlsm. i tried the code below and received thiS error message "run time error 1004 application-defined or object-defined error".
Bookmarks