Marco to compile data to another worksheet based on criteria

[SilverFox]

Hi

Could someone please help me out with this, I have a workbook with one sheet and a lot of data. What I am trying to do is this.

I have Columns A – G

In A column I have a Code and in G column I have a Pack Size

What I am trying to do is this, I need a macro that would look at A column looking for a match, when it finds a match it would then look at G column, if the numbers in G column is different I need them listed on another work sheet.

So if A1 & A125 were the same code lets say 00001 and G1 and G125 were different lets say G1 was 6 and G125 was 12 I need a new sheet listing A – G columns for both A1 and A125, I would like these together. In some cases I may have the A1 code listed 3 or 4 times in that case I would need all 3 or 4 listed

Any help would be very much appreciated.

[SilverFox]

I have added a sample sheet to show you what i need. As you can see the ones highlighted in Grey need to be listed on another sheet as the G column is different

The ones highlighted in Blue do not need to be listed as the G column is the same

[SilverFox]

Can someone please help me with this or point me in the right direction. The workbook i have has over 50k rows so it is not easily sorted, this would be a great help if anyone can help, or just to let me know it can not be done will be fine.

Many Thanks

[SilverFox]

Last try to see if anyone can help me out on this?

[SilverFox]

Ok thanks anyway guys you have been very helpful in the past, obviously this can't be done.

[arlu1201]

Hey, you need to wait for a day atleast before you bump the post. You have already bumped it thrice today.

[SilverFox]

Point taken, i was just in a hurry to get this job done, it won't happen again. I am going through it manually today.

Cheers