Copy specific data from one workbook to another workbook with certain criteria

Hello Guru,

I am trying to copy certain data from one book to another.

Example: Master file contain all kind of orders. i.e. Order No. starts with P-1234; ST-5145; MI-98705; etc. so what i am looking on it is, if file starts with "P" it will automatically updated in Report file in Sheet named as "Series P" and "ST" it will automatically updated in Report file in Sheet named as "Series ST" and "MI" it will automatically updated in Report file in Sheet named as "Series MI" and "RI" it will automatically updated in Report file in Sheet named as "Series RI" respectively with Sr. No, Order Number, Completed Date and Status.

In Report file all need is completed files only. Pending and Cancelled files are not required.

Somewhat i am new with macro's however comfortable with excel.

Thank you...
...Marc

Should the report file be opened by the macro?

Do you want the path to be specified or should the user be prompted to open the file?

Do you want the macro to check if the sheet exists or not in the report file?

Try this code

Please Login or Register  to view this content.

Put it in a standard module. Change the bold section to match your system.

Updated code -

Please Login or Register  to view this content.