Adding new row to the top of a table using macro button?

EDIT: My client decided they want the data displayed differently, so I no longer need the answer. However, I'm curious how you'd go about this if anyone still wants to figure it out!


I'm building a spreadsheet for my work to help organize maintenance data for all of our company's trucks. I'm not going to be the person entering data past creation of the project, so I want to make sure it's as simple as possible for anyone to add data to it.

Now, by default when you add a new row to a table, you click the bottom right corner of the last row and hit TAB. I'd like to add a macro button that adds a new row to the TOP of the worksheet instead of the bottom. I'd like it to copy and past info from a (mostly) blank row that has some hidden data in a few columns.

Here's a quick little simple mock-up of what I'm doing so I can explain why it needs to work this way.

Capture.PNG

Most of it is pretty self explanatory, the "tag data" columns are going to be hidden and only matter for pivot tables that will use this data (it's stuff like the vehicle number, make/model, etc for internal comparisons), and there's a total KMs, total service cost, and the "Next Service", which is just the current KM + 6,000 so we can project when a vehicle needs to be scheduled for service. The most recent service is at the top of the table, the oldest service is at the bottom. Believe me, I asked why we can't just have them swapped but this is how they want the data displayed so this is how it's gotta be.

So I'd have my Add Row button, the macro would copy the data from the top row in the table under the header (Row 6 in my example), add a new row, shift the existing data down 1 row, paste the data into the new top row.

Capture2.PNG

There's going to be multiple tables in this sheet, one for each vehicle, since we're condensing down roughly 100 separate spreadsheets into one big one for ease of use and data analysis purposes.

Seems straightforward enough but I can't quite seem to get it working!

Edit: Unfortunately I can't post any links yet because I'm a new user.

I've attached my example sheet though!

When you copy the data from the top row, are you copying only from column F to the last used column? If so, what is the last column used? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).