Simple data entry form above the targeted columns.

[mrmikepan]

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

[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.

[mrmikepan]

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"

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.

[kvsrinivasamurthy]

Read this
Select the range C4:G10 Form C4.

As
Select the range C4:G10

[mrmikepan]

I think you misinterpreted what I'm trying to do, or maybe I didn't explain it well enough.

I have 4 cells that I want to enter data into C4,D4,E4,F4.
Underneath those 4 cells its suppose to be a list of what I've entered.
I want to type data into C4,D4,E4,F4... Push a developer button labeled "Enter" and then have that data be put onto the bottom of the list, clearing C4,D4,E4, and F4 for the next set of data to be added to the list.

To do this it must go down the list and find the first blank row for the data from (C4,D4,E4,F4) to be placed, When the developer button labeled "Enter" is pressed. At least I think that's the easiest way to accomplish this? I don't know VB code.

Read this
Select the range C4:G10 Form C4.

As
Select the range C4:G10

[kvsrinivasamurthy]

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

[mrmikepan]

Any help with this anyone? Please.