Simple data entry form above the targeted columns.

I've been searching and searching for this simple simple how-to, but I'm done trying to sort through all the excel help that's just a little bit different than what I want.

So... I have a table with 4 columns, these are the headers:
Date / Item Name / Purchase From / Purchase Price
Table Starts @ B3, Headers C3 / D3 / E3 / F3 (Same order as above)
I want to be able to type in the data in C4 / D4 / E3 / F3, press an 'Enter' Button Near G4.
It will automatically place the data in the next open row for each column. "Adding it to the List"

Seems simple, but I have no clue... If someone could show me what to do I would be so appreciative and hopefully I'll be able to modify the efficiency of how I want to enter the data from there.

Thank You!

PS: Still learning so explanations of the code are soo welcome

First set the selection move to right when Enter key is pressed.

If you want to enter data from C4 to G10, Select the range C4:G10 Form C4.
Now C4 is active. after typing data press 'Enter'.Now D4 will activate.Continue.
after Typing data in G4,Press 'Enter' Key.Now C5 is activated.

I want to enter data in C4 / D4 / E4 / F4
BTW I'm using excel 2013, and you lost me here: "C4:G10 Form C4"

Originally Posted by kvsrinivasamurthy

First set the selection move to right when Enter key is pressed.

If you want to enter data from C4 to G10, Select the range C4:G10 Form C4.
Now C4 is active. after typing data press 'Enter'.Now D4 will activate.Continue.
after Typing data in G4,Press 'Enter' Key.Now C5 is activated.

Read this
Select the range C4:G10 Form C4.

As
Select the range C4:G10

If all cells are empty the first entry of C4:F4 Are to be transfered to which cells.

Any help with this anyone? Please.