copy/paste based on duplicate cell value in column

Sabosis

New Member
Joined
Apr 18, 2013
Messages
2
Hello-
I need a code to copy/paste based on duplicate cell values in a column. Please see example below. I want to take values from A2:B2 and paste to C1:D1 if there is duplication in E1:E2. Then loop through the rest of the spreadsheet. Any ideas? Thanks :)
Sample
A B C D E
111 222 ABC
333 444 ABC
555 666 DEF
777 888 DEF
Result
A B C D E
111 222 333 444 ABC
333 444 ABC
555 666 777 888 DEF
777 888 DEF
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sorry, my first post... Please note that in the sample, columns A & B would hold the numeric sets and column E would hold the alpha values. C & D are meant to be blank. In the results, the first row would show how columns A:E would look. I was not aware that info could be put into tables for posting and cannot edit the original post at this time. Sorry my example is messed up.
 
Upvote 0

Forum statistics

Threads
1,215,692
Messages
6,126,227
Members
449,303
Latest member
grantrob

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top