VBA - Code for comparing two sheets and extracting rows based on unique column value

[Starbel]

I was hoping for a code that will compare 1000s of entries in column A between sheet 1 and sheet 2 - and then extract the rows of those unique values in column A onto a new sheet (sheet 3)

See below from example -

Sheet1
1	QWE	DOG	QWE	DOG
2	ASD	CAT	ASD	CAT
3	ZXC	MOUSE	ZXC	MOUSE
4	QWE	DOF	QWE	DOF
5	ASD	CAT	ASD	CAT
Sheet 2
1	QWE	DOG	QWE	DOG
2	ASD	CAT	ASD	CAT
3	ZXC	MOUSE	ZXC	MOUSE
4	QWE	DOF	QWE	DOF
5	ASD	CAT	ASD	CAT
6	ASD	TIGER	ASD	TIGER
7	WE	WE	WE	WE
Sheet 3
6	ASD	TIGER	ASD	TIGER
7	WE	WE	WE	WE

 

[Starbel]

Hi,

Hope you're all well!

Sorry I've had to bump this due to a mistake made when posting the question.

I am somewhat of a novice when it comes to VBAs/Macros. Just really know how to enter codes and run them - hopeless when it comes to understanding what is what etc. I have a long way to go

Basically, I was hoping for a code that will compare 1000s of entries in column A between sheet 1 and sheet 2 - and then extract the all rows related to the unique values in column A onto a new sheet (sheet 3)

Much appreciated guys


See below from example -

Sheet1
1	QWE	DOG	QWE	DOG
2	ASD	CAT	ASD	CAT
3	ZXC	MOUSE	ZXC	MOUSE
4	QWE	DOF	QWE	DOF
5	ASD	CAT	ASD	CAT
Sheet 2
1	QWE	DOG	QWE	DOG
2	ASD	CAT	ASD	CAT
3	ZXC	MOUSE	ZXC	MOUSE
4	QWE	DOF	QWE	DOF
5	ASD	CAT	ASD	CAT
6	ASD	TIGER	ASD	TIGER
7	WE	WE	WE	WE
Sheet 3
6	ASD	TIGER	ASD	TIGER
7	WE	WE	WE	WE