Hey all,
I am a bit stuck on how to go about this.
I have a range of data on sheet1 that holds employees data, I need to constantly update this and add employees data as they are employed. I import a file that has all the recently added employees(Sheet 2) and I need to search through sheet 1 and see if that persons data is on sheet 2. If it exists on sheet 2 then move to the next employee. When I find an employee that has no no data on sheet1 , copy the entire row.
Here is a sample WB.
Bookmarks