Reply to thread

Message

[QUOTE="Constantly Amazed, post: 3676124"]
Hi

I have a spreadsheet which contains a record of item types that an
individual can sign for.  However for each individual the item type is
repeated for each cost centre.
ie
Name                Cost Centre          Item
George Brown    AAAA                  Invoices
George Brown    AAAA                  Staff Return
George Brown    AAAB                  Invoices
George Brown    AAAB                  Staff Return
Ann Johns          CCCD                 Invoices
Ann Johns          CCCD                 Leave Forms
Ann Johns          CCCD                 Expenses
Ann Johns          CCCE                 Invoices
Ann Johns          CCCE                 Leave Forms
Ann Johns          CCCE                 Expenses

What I want is a macro that will look at the cost centre and delete any
lines from the persons record that has the same cost centre in it leaving one
entry per person per cost centre.

Name                Cost Centre          Item
George Brown    AAAA                  Invoices
George Brown    AAAB                  Invoices
Ann Johns          CCCD                  Invoices
Ann Johns          CCCE                  Invoices

This needs to continue until the macro reaches the last row containing any
data in the cost centre column.

I've tried the advanced filter for unique records but cannot do it this way.

In the spreadsheet the cost centres are actually oin column 4 and the
forename and family name are in column 1 and 2 respectively.

Thanks for any help.
[/QUOTE]

Verification