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

[Closed]
Report
Posts
2
Registration date
Thursday July 23, 2015
Status
Member
Last seen
July 23, 2015
-
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!