Hi Everyone,
I have 2 workbooks namely Masterlist.xlsx and REGULAR.xlsx both have the sheet named LIST with the following formats
A B C D E
1 EMPLOYEE NUMBER NAME LOCATION DATE OF HIRE STATUS
2 123578 Michael Jordan New York 01/18/11 Regular
3 321666 Kobe Bryant LA 02/31/13 Prob
What I want to do is to copy A2:E2 from the Masterlist.xlsx if the value of E2 is "Regular" or blank. Then paste it to the workbook REGULAR.slxs at the bottom row so I wont overwrite existing data. Additionally, I dont want to paste rows that was already pasted after rerunning the code multiple times.
I badly need your help.
Thanks a lot!
Bookmarks