How to find a row heading and replace the data in the next col

Closed
pranoopz Posts 2 Registration date Thursday July 23, 2015 Status Member Last seen July 23, 2015 - Jul 23, 2015 at 04:13 AM
I have excel data sheet in following format
Row Heading Row Value
name XYZ
address ab
id 11

Now I need to write a macro which can find the row with 'name' and 'id' and replace

XYZ and 11 with a value entered by user in macro input.