MS Excel 2010 Data Entry - Display Current Data on Top

Looking for the most simple way to create a data entry xls where the most recent entered data is displayed at the top of the list.

Data will be entered in columns A thru G of Row 1.  When user enters a Hot Key or click a Save button in column H then the Row 1 data should be moved to Row 4.  All the data that was stored in Row 4 and downwards would then be moved 1 row down.

So if data existed in Rows 4 thru 10 and a user entered and saved a new row in column 1 the ending result would be data in rows 4-11 with the most current entered data in row 4.  After moving the entered data from row 1 to row 4 the columns A-G in row 1 should be reset to blank.
dlpotlatchAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steven HarrisPresidentCommented:
Data will be entered in columns A thru G of Row 1

I am assuming you mean A1 through G1 is where the data will be entered:

Create a button (or other control object) in H1.  Use the following Macro:

Sub Button1_Click()
    Range("A1:G1").Copy
    Range("A4:G4").Insert Shift:=xlDown
    Range("A1:G1").ClearContents
End Sub

Open in new window


Example sheet attached.
Newest-First-Macro.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dlpotlatchAuthor Commented:
Works great, thanks for fast response.  We may have some future Excel technical questions/consulting requirements.   Would you consider taking some of these on for a fee per question basis ?
0
Steven HarrisPresidentCommented:
Experts Exchange has a Job Board available.

You can also check for relevant qualifications via my profile.
0
Saqib Husain, SyedEngineerCommented:
Although the question is closed here is a method which I have been using which involves the worksheet_change trapper. You do not have to click a button or invoke a shortcut key.

As soon as you enter anything in row 1 to 4 and columns 1 to 7 that row is moved to row 5 and you can continue working in row 5.
Autoinsert.xlsm
0
dlpotlatchAuthor Commented:
Thanks much for posting the worksheet_change method.  Can see where I could use this as well.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.