Hallo again lovely people!
As part of a (horribly large!) report I do each month I need to delete all duplicate reports, the unique reference for these is "Report number", which are in column B
My problem is once I have identified and deleted these from column B Using ASAP utilities) I also then want to delete the surrounding cells as I have columns A:J with data in that is used in assorted formulae around the rest of the report
So... could anyone help with a macro to find a duplicate in B8 (like ASAP does) then delete (shift cells up) Cells A8:J8
I have got as far as sorting by the report number and highlighting column B ready to delete the duplicates, so not very far then!
Very many thanks in advance
Rae
Bookmarks