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

Registration date
Thursday July 23, 2015
Last seen
July 23, 2015
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!