N
Neil
Hi
I currently have a list (List A) off addresses that have certain information
such as grid points, type etc. I also have a list (List B) that is currently
being created and i would like to be able to delete anything off list A
(that has the extra detail) against list B that is being generated and added
to daily. So i am left with List A matching list B and still retains all the
extra data in it. I am using Column E for house number and Column H for the
road name in both lists. I tried to use an advanced filter but that just
deletes the duplicates leaving me with the addresses i don't need. I wasn't
sure if i could put something in the last column AH to high light the
duplicates so i could filter the column and be left with my complete list.
Ideally i would like to be able to check it every other day as list b grows.
Hope this makes sense!
Many thanks for looking
I currently have a list (List A) off addresses that have certain information
such as grid points, type etc. I also have a list (List B) that is currently
being created and i would like to be able to delete anything off list A
(that has the extra detail) against list B that is being generated and added
to daily. So i am left with List A matching list B and still retains all the
extra data in it. I am using Column E for house number and Column H for the
road name in both lists. I tried to use an advanced filter but that just
deletes the duplicates leaving me with the addresses i don't need. I wasn't
sure if i could put something in the last column AH to high light the
duplicates so i could filter the column and be left with my complete list.
Ideally i would like to be able to check it every other day as list b grows.
Hope this makes sense!
Many thanks for looking