billigee
New Member
- Joined
- Sep 18, 2020
- Messages
- 24
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
- Mobile
- Web
Hi All,
I need a macro with loop which check duplicate value from column one and copy data from its next four columns and paste in blank columns
For eg
In Column A Row 1 there are item codes and column B,C,D,E have details of conversion
And in Column A row 2 have same code with other conversion details in Columns B,C,D,E
Same as in Column A Row 3
I want Macro to copy conversion (BCDE) details from each duplicate code in column A and paste in next blank column (FGHI)
So thats how I will have unique codes in column A and its conversion details in column B,C,D,E and F,G,H,I and so on
currently its like this
after macro running it should like this
Any help will be much appreciated.
Thankyou
I need a macro with loop which check duplicate value from column one and copy data from its next four columns and paste in blank columns
For eg
In Column A Row 1 there are item codes and column B,C,D,E have details of conversion
And in Column A row 2 have same code with other conversion details in Columns B,C,D,E
Same as in Column A Row 3
I want Macro to copy conversion (BCDE) details from each duplicate code in column A and paste in next blank column (FGHI)
So thats how I will have unique codes in column A and its conversion details in column B,C,D,E and F,G,H,I and so on
currently its like this
after macro running it should like this
Any help will be much appreciated.
Thankyou