Hi
I would like to add some code to an existing macro that will filter the data in the attached in a example workbook.
I would like to filter out all the data I have marked in red text ( not normally like this ).
The data varies in amount from day to day, in column A there is some matching data, i.e. A3 matches A4, both have a 1 next to them in B3 and B4 this would need to be removed, but also A10,A11 and A12 match each other and have 1 in the corresponding rows in column B this would also be removed.
Im not sure where to start ?
Thanks
Bookmarks