Forum Discussion
Logbook Entry at top - new row required
Hi
I recently wrote a pilot logbook with TOTALS formulas myself, and the flight entries are in row chronological order, with the latest/newest entry at the top of the spreadsheet. How do I get the spread sheet to automatically produce a new line at the top of the spreadsheet as I am filling in the last flight details, dready for the next flight details please?
Thanks...
6 Replies
- You would have to add VBA (Macro) to automatically add a new row.
As a practical alternative I'd suggest turning your table of data into a Table using Ctrl T and then whenever you want to add a new row just Right Click on the first row and choose Insert > Table Rows Above- Hi. Thanks. I know how to inert rows but I thought there might be a neat solution that XL could automatically add another row above the row that’s having data inputted, ready for the next row of data above...
- No sorry, the best you're going to get is a one click solution with VBA so it's not really worth it given the built in 2 click solution with Tables
