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

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

Welcome to the Forums.

Are you doing this in VB6 or just Excel's VBA? Re-attach your code or post it.

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

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

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

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

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.