Macro to find all specific values in column and replace adjacent cell values

**dblock02** · 02-10-2012, 02:59 AM

Hello,

Via macro, is there a way to find all specific values within a column, then replace the right adjacent cell values of each value found with the values in the cell directly above the adjacent cells?

For example, I have attached a spreadsheet with four product values in Column B (Hardware, SW, Installation, Shipping). I would like to find all “SW” items in column B, and replace the Date in column C with the Date of the “Hardware” item in the row directly above the “SW” item. I would then like to repeat this same action for “Installation” and “Shipping” rows.

The data I receive will change daily, and the SW, Installation, and Shipping lines would always need to be updated with the date as the HW line directly above.

Thanks for taking a look!

**royUK** · 02-10-2012, 03:12 AM

Is this what you mean?

Please Login or Register  to view this content.

**dblock02** · 02-11-2012, 10:56 PM

Perfect!!!!! Thank you very much royUK!!!

**gmonak** · 07-23-2013, 06:03 AM

@royUK. Can you please explain your code step by step? I'm faced with a similar challenge and I want to adapt your code to solve my problem.

So please, if you can explain what each step of your code does, especially, rRng, rCl and the rRng setting.

Thanks