Hi expert, I am a new excel user and trying to use VBA to do the copy and paste automatically from one workbook to another workbook.
This is the monthly report I am doing every month, there is a raw data file called (a1_wct6) which generate from foxpro program and I have to copy the date and the data to another workbook (trend_local_ztess). The format of file (a1_wct6) is not changed, it's just changed the date such as Oct in my file, but I have to copy the data to a varient file (trend_local_ztess) because the data will be accumulated so that the row number will be increased every month.
It's much appreciated if anyone help me how to use VBA code to copy the data automatically ?
I have attached both files for your reference. Thanks so much !
Bookmarks