compare 2 sheets and extract common and error rows into another sheets
Hope someone can help this poor newbie!
Allow me to explain.
I have a Excel Work Book with 2 Sheets named Caller(100 rows)and Subscriber(500 rows).
Caller contains 2 columns: one is audio file name(with .au extension)
and other is the content in that audio file.
Subscriber also contains 2 columns: one is audio file name(with .au extension)
and other is the content in that audio file.
Now what I wish to do is to compare Caller and Subscriber and:
To remove the common rows from Caller and Subscriber and place them in sheet3.
To remove the rows if it satisfies any of the following error conditions and place them in sheet4:
i)if any .au extension is missing in the column1 in both sheets
ii)if data in column1 is same and data in column2 is different
iii)if data in column2 is same and data in column1 is different.
I am herewith attaching the code I was able to prepare but not able to get the exact output.
Many thanks in advance.
With Regards,
Rajesh
Re: compare 2 sheets and extract common and error rows into another sheets
Quote:
Originally Posted by raj_thota
Hope someone can help this poor newbie!
Allow me to explain.
I have a Excel Work Book with 2 Sheets named Caller(100 rows)and Subscriber(500 rows).
Caller contains 2 columns: one is audio file name(with .au extension)
and other is the content in that audio file.
Subscriber also contains 2 columns: one is audio file name(with .au extension)
and other is the content in that audio file.
Now what I wish to do is to compare Caller and Subscriber and:
To remove the common rows from Caller and Subscriber and place them in sheet3.
To remove the rows if it satisfies any of the following error conditions and place them in sheet4:
i)if any .au extension is missing in the column1 in both sheets
ii)if data in column1 is same and data in column2 is different
iii)if data in column2 is same and data in column1 is different.
I am herewith attaching the code I was able to prepare but not able to get the exact output.
Many thanks in advance.
With Regards,
Rajesh
sorry but i cant see your code here
Re: compare 2 sheets and extract common and error rows into another sheets
Welcome to the Forums.
Are you doing this in VB6 or just Excel's VBA? Re-attach your code or post it.
Re: compare 2 sheets and extract common and error rows into seperate sheets
Welcome raj_thota! :wave:
First of all: Please, don't post duplicates. You could have just made another post in your earlier thread and attached the document there.
Second: You can post VB code between the [VBCODE ] and [/Highlight] tags.
And then to the problem. Are you sure you're using VB6? I'm not quite sure, but that looks more like VBA. :ehh: And I don't really know VBA :(
And what do you mean by this, please be more specific:
Quote:
ii)if data in column1 is same and data in column2 is different
iii)if data in column2 is same and data in column1 is different.
I'll do my best to help you :)
rade
Re: compare 2 sheets and extract common and error rows into seperate sheets
Thank you very much Rade for taking interest,
ii)if data in column1 is same and data in column2 is different
iii)if data in column2 is same and data in column1 is different.
What actually i mean is that same file name with different contents shouldnt be present in the Caller as well as Subscriber sheets. And also different files names with same content shouldnt be present.
I hope you got what i want to convey.
Thanks
Rajesh
Re: compare 2 sheets and extract common and error rows into another sheets
I am doing this in VBA.
sorry i have attached the files and posted them in a new thread.
now, there are two threads on same topic.
how to disable this thread. so that the flow is maintained on single thread.
Rajesh
Re: compare 2 sheets and extract common and error rows into seperate sheets
Quote:
Originally Posted by raj_thota
Yes Rade I am using VBA
Rajesh
Sorry I don't know a thing about VBA :(
Hope you get help soon!
rade
Re: compare 2 sheets and extract common and error rows into another sheets
Quote:
Originally Posted by raj_thota
how to disable this thread. so that the flow is maintained on single thread.
Rajesh
Send a PM to a mod and request that the two be merged, or one of the two be deleted. :)
Duplicate Threads merged and VBA question moved to Office Development.