Hi,
I have 2 WS with exact number of columns A through Y with the same header names. However, the columns on both WS are sorted differently and one WS has more rows of data than the other. I would like to compare data from Columns C D E in WS1 to C D E in WS2. If they matched, then copy the data from Columns N O P Q R S T U V from WS1 to the same columns in WS2 and copy the data from column Y M from WS2 to the same columns in WS1. Thanks.
I have 2 WS with exact number of columns A through Y with the same header names. However, the columns on both WS are sorted differently and one WS has more rows of data than the other. I would like to compare data from Columns C D E in WS1 to C D E in WS2. If they matched, then copy the data from Columns N O P Q R S T U V from WS1 to the same columns in WS2 and copy the data from column Y M from WS2 to the same columns in WS1. Thanks.
