Team,

Please suggest me on my below requirement.

1) In my file I have 4 sheets.
2) In each sheet I will have Same Columns from A to F
3) In Column G I will have status for each row (PASS / FAIL / FIX)
4) I need a macro which show the Duplicate rows in all the Sheets in which COLUMN G Status = "FAIL".

The macro should create a separate sheet with A to G column to show the Common Rows in all the existing sheets with Status as FAIL.

Thanks!
Kiran

Hi Kiran,

If you have Office 365 Professional Plus, Excel 2010 or 2013 Standalone or Professional Plus editions, you should consider using Power Query Add-in for Excel to achieve your goal. It will allow you to perform the task at hand with few mouse clicks. The result can be loaded to a new worksheet, and clicking Data->Refresh will automate the process whenever your data changes.

I can send you step-by-step instructions once you install the add-in.

Download link here.

More info on Power Query here.

I can promise you will like it.

Gil

Excel team

Hi Gil,

Is it Freeware or Licensed one.

Thanks!
Kiran

If you have Office Professional Plus or Excel standalone editions you are ready to go. It is free.