Copying Adjacent Cell to it's Duplicate.

[JEBianchi]

Hello, Please excuse the inexperience! I am looking for help with copying the adjacent cell of a known duplicate to the adjacent cell of its match. For example; When I find the corresponding number I am looking for and enter it into D31, I would like for that value to also enter D45 and where ever else there may be C31's duplicate. Is this something that may be possible? Thank you in advance for your time!

SNAG-0013.jpg

[Richard Buttrey]

Hi,

Maybe in E31

Please Login or Register  to view this content.

Copy this down the rows and then if necessary copy column D and paste back to column C as Values.

Untick the File-Options-Advanced-Display options for this sheet-display zero values as zero.

[JEBianchi]

Ciao Richard, thank you for your response! I seem to be struggling a bit. Which column should I put the code in?

[Richard Buttrey]

As I mentioned, put it in cell E31 and copy it up and down the column.

I only mentioned E31 since that was the specific example you mentioned. If , as is likely your data starts in row 1 then you could have put the formula in E1 changing all the references to row 31 to row 1.