Excel Data Entry Form

[Ajohn403]

I've created a nice spreadsheet for my office.
It has a few columns, Name, ID, Date, Notes, Archiving
and a few thousand entries.

My idea / question would be, Is there a way to have a button on the sheet that will take you to a cell (or group of cells) that you can enter
NEW data ( name, id, date, notes, archiving) and have it automatically be added to the bottom of the document using a button..
A button to take you there, and once there, a button to select the 5 cells to the left of it and copy and paste them down to the bottom of the
data (where the last data was entered).. and go back to the "data entry point" cells
Is this too complicated?
any help is appreciated.. thank you!

[daffodil11]

Not hard, very good chance to get your feet wet on programming if you're new to it.

Insert->Shape->Choose a shape for button
Right click the shape after drawing shape. Assign Macro. Choose New

Now your do programmy type stuff. (I chose a rectangle, your macro name may differ)

I had input box things at B11, D11, F11, H11, J11, I11.

I copied the box headers like.. 100 rows down to hide the data stuff.

LR is a little magical variable I made that finds where the last records was sent to. The button copies the inputs on line 11, and sends them 100 lines down to last row.
Then it clears the input boxes.

Please Login or Register  to view this content.

[Ajohn403]

Awesome!!
Thank you for such a fast and simplified reply.
I'll attempt to apply this to my sheet!