Hi
I am trying to create some code to filter two sheets using specific criteria, scan both sheets for matches then where a match is found to transfer data over but when transferring my current code finds the previous entries instead of those filtered.
What I need is to filter columns 10+11 in sheet 1, filter column 10 in sheet 2, then use column A in sheet 1 to find matches in column L sheet 2. Then transfer cell data from column b, c, f etc (not whole row) to the matching row and columns of sheet2. Sheet 2 however will have matching criteria which does not have a status of Assigned, therefore this needs to be skipped.
Can you help please with the following code or if there is a better way to do it
Bookmarks