Need help!
If any change in done on any cell of a row. Then macro looks for the duplicate value across Column B. If any duplicate found, then copy entire row to the row, where duplicate is found in cell in column B.
The idea is to have similar rows, wherever is any duplicate in Column B. Trigger for the whole process is - if any value changes in a row.
Please ask me.. if you are not clear about my question.
Thanks guys!!
If any change in done on any cell of a row. Then macro looks for the duplicate value across Column B. If any duplicate found, then copy entire row to the row, where duplicate is found in cell in column B.
The idea is to have similar rows, wherever is any duplicate in Column B. Trigger for the whole process is - if any value changes in a row.
Please ask me.. if you are not clear about my question.
Thanks guys!!