Hi all,
I need help comparing two sheets, if any row in sheet2 already exist in sheet 1 , then cut and paste it into a sheet3
Thank you very much
Hi all,
I need help comparing two sheets, if any row in sheet2 already exist in sheet 1 , then cut and paste it into a sheet3
Thank you very much
What is the comparison based on? A particular column?
"If ID in A1 on Sheet2 exists anywhere in column A on sheet1, then move the whole row from Sheet2 to Sheet3...repeat for all of Sheet2 column A values."
Something like that?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
compare the whole row, (the data in each cell of that row)
Hi VBisgreat
This could be done with concatenation. How many columns are you talking about and how big are the files?
John
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
I agree with jaslake : you should concatenate all the cells in one.
The syntax for the CONCATENATE function in Excel 2007 is:
= CONCATENATE ( text1, text2, ... text30 )
Text1, text2, ... text30 can be words, cell references, blank spaces, or numbers.
When it's done, you can use this comparison service to find identical lines in both files.
On step2, select the colum where you have made the concatenation in each file.
Best regards
Marc
I don't know what comparator service is referenced in xlcomparator's post but a service is not required.
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks