Compare 2 sheets pick up unique and copy rows to another Sheet

**dungoc** · 08-23-2013, 09:36 AM

Hello Experts,

I have 2 sheets CASH & BANK contain data, I would like to compare between 2 sheet and Extract unique Name to third sheet (REPORT) where it collects data for a whole rows from Cash & Bank please see attached for file (Report sheet which I want formular to do the work)

comparepickupunique.xlsx

Appriciate for you help.

Thank
Dominic

**Richard Buttrey** · 08-23-2013, 09:44 AM

Hi,

Before doing that why don't you simplify your data and just have one sheet but with an extra column that identifies whether a row record is a Cash or Bank item?

Doing it that way will immensely simplify your current report as well as any other reporting and you will also gain the huge advantage of opening up the powerful Pivot Table functionality.

**dungoc** · 08-23-2013, 10:08 AM

thank Richard, thank you very much for your time for the advise, but it can not apply here.

I've just combined to sheets together , because in a realtime 2 people do difference worksheet (1 for the bank data, 1 for cash data) they not allow to see each other...

Dominic

Originally Posted by Richard Buttrey

Hi,

Before doing that why don't you simplify your data and just have one sheet but with an extra column that identifies whether a row record is a Cash or Bank item?

Doing it that way will immensely simplify your current report as well as any other reporting and you will also gain the huge advantage of opening up the powerful Pivot Table functionality.