Need a Macro program to push values against fixed reference values in different columns

Hello Everyone,

I am designing an Input Form and Database system in MS Excel, and use the 2010 version of Excel.

What do I need?
- I have a Database that has two columns with fixed information i.e. Registration Number and Name of Person.
- In the Input Form, I will look-up the Registration Number (that I already know) and the Name of Person will automatically appear (Basically a vlookup)
- Now, I want to update more information against different parameters for the respective Registration No/Name of Person
- Once I update, the information/value against the parameters should go and sit in the same row alongside the respective Reg. No/Name under different columns.
- Once the information/value gets recorded, I can erase the information entered in the Input Form and later follow the same procedure for other Reg. Nos/Names.

I hope you all have understood what I need. I have attached the Excel sheet for your reference. Please help me out with this one.

Thanks,
Varhead

Hi Alvaro,

That worked perfectly! Thank you so much for your assistance. I racked my brains searching for a solution on the internet and with my peers too, but nothing worked out. This is right on target! Made by day

Thanks Again!

Varhead

Hi Alvaro,

Just one doubt!

If i enter a value against Field 1 i.e. G15 and Field 3 i.e. G17 and run the Macro, the contents will get recorded under the respective column. If i enter a value against Field 2 i.e. G16, and run the macro, it erases the previously recorded values of G15 and G17 and only displays G16.

I might be related to rngField.ClearContents, but need to know how do i modify it to suit the current need

Thanks,
Varhead