Finding a particular row title and editing the value in next col

pranoopz Posts 2 Registration date Thursday July 23, 2015 Status Member Last seen July 23, 2015 - Jul 23, 2015 at 05:39 AM
Hello All,
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.

Can someone please help me out in this regard to write a macro to modify the data accordingly. Help is very much appreciated.

Thanks in advance.