Hi everybody,
On my work sheet my first column is customer names. the rest are notes, contacts etc.. upon a second contact with a customer i would like to compare this Name cell with the above Name cell e.g.
range("A" & activecell.row)
with
range("A" & activecell.row - 1)
if they're the same Id like to merge the cells (so name appears once for each customer) works better with filters etc -
this works fine for 1 additional contact. however when a 3rd contact is made it doesnt pick up on activecell.row -1 because its already been merged (and now referenced differently)...
Has anyone any suggestions (ideally something like activecell.above) or a work around,
Thanks for any replys
On my work sheet my first column is customer names. the rest are notes, contacts etc.. upon a second contact with a customer i would like to compare this Name cell with the above Name cell e.g.
range("A" & activecell.row)
with
range("A" & activecell.row - 1)
if they're the same Id like to merge the cells (so name appears once for each customer) works better with filters etc -
this works fine for 1 additional contact. however when a 3rd contact is made it doesnt pick up on activecell.row -1 because its already been merged (and now referenced differently)...
Has anyone any suggestions (ideally something like activecell.above) or a work around,
Thanks for any replys