Hi i have a workbook where i need to find match between sheet named "connections" column A
and sheet named "filtered" column B.
When it find the match it need to copy the row with matches in sheet "connections" to sheet "match
and it need to copy the row with no matches in sheet "connections" to sheet "no ´match"
p.s there can be many rows in the real workbook
There is header in all sheets and i have attached a test sheet to see it.
Please have a look. Thanks in advance
Sincerely
Abjac
How about
Please Login or Register to view this content.
I think this should work. The macro name is CopyRanges2.
I mad use of Excel tables. There are many advantages to excel tables: http://www.utteraccess.com/wiki/Tables_in_Excel
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
I think this should work. The macro name is CopyRanges2.
I used Excel tables. There are many advantages to excel tables: http://www.utteraccess.com/wiki/Tables_in_Excel
HI Fluff13 and dflak. I tried both solutions and both work really good. So both of you thanks allot.
really great.
Sincerely
Abjac
Glad we could help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks