Hi guys,
I would like to create a macro/VBA that allows me to delete and entire row only if the cell value is the same as the cell value above.
[TABLE="class: grid, width: 500"]
[tr][td]Type
[/td][td]Price
[/td][/tr][tr][td]A
[/td][td]12.00
[/td][/tr][tr][td]A
[/td][td]12.00
[/td][/tr][tr][td]B
[/td][td]15.00
[/td][/tr][tr][td]C
[/td][td]20.00
[/td][/tr][tr][td]C
[/td][td]20.00
[/td][/tr]
[/TABLE]
So in this table I will add buttons that will allow rows to be deleted individually only if the cell value in column 'Type' is the same as above. Also the range of column 'Type' is unknown.
Hope you can help?!
Cheers
AMQ