MS Excel 2010 Data Entry - Display Current Data on Top
Posted on 2014-01-18
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.