Find and delete
Sheet 1 is the Master list (of accounts), sheet 2 is the list of paid
accounts - these rows need to be removed from the Master list (sheet 1). The
column with the the unique references is J on both sheets.
Thanks
Philip
"Otto Moehrbach" wrote:
Philip
Is "Sheet 2" the "Master" list?
What column(s) do you want to look at to determine if the listings are the
same? Do you want to delete from the Master list or from the other sheet?
HTH Otto
"Philip Drury" wrote in message
...
Hi, have a workbook with 2 spreadsheets, first one is the master list
(with
unique references), second one is an extract (containing duplicated data).
Can anyone help me with a way of looking at the unique references on sheet
2,
finding the duplicate reference on sheet 1 and deleting the row from sheet
1??
Any help much appreciated
Philip
|