M
MCheru
I have a worksheet and Columns A:C have contents in them. The contents in
every row belong together. So A1, B1, and C1 belong together, A2, B2, and C2
belong together and so on.
Every cell in Column A typically has between 10 and 15 characters.
Every cell in Column B has between 30 and 35 characters.
Every cell in Column C has 1 number in it which could be one or two digits.
I’d like to create a macro that will search column A:B. Every time a
character is repeated in Column A:B, I want to delete that row but take the
quantity in Column C that is associated to the row that was deleted and add
it to the quantity in Column C of the original character in Column A:B that
was identical but did not get deleted.
Might you help me?
every row belong together. So A1, B1, and C1 belong together, A2, B2, and C2
belong together and so on.
Every cell in Column A typically has between 10 and 15 characters.
Every cell in Column B has between 30 and 35 characters.
Every cell in Column C has 1 number in it which could be one or two digits.
I’d like to create a macro that will search column A:B. Every time a
character is repeated in Column A:B, I want to delete that row but take the
quantity in Column C that is associated to the row that was deleted and add
it to the quantity in Column C of the original character in Column A:B that
was identical but did not get deleted.
Might you help me?