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?
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...