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 ...
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
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
Wyn Hopkins Aircraft Logbook Column has column of aircraft Registrations G-TUIA to G-TUIJ. Types TUIA to TUII are type 787-8 and TUIJ to TUIN are type 787-9.
When I type in the registration, how do i get the next column to automatically fill in the type?Hi BEN_FAWKES,
Please check the solution posted.
https://techcommunity.microsoft.com/t5/excel/pilot-logbook/m-p/1215928
Regards, Faraz Shaikh
