Forum Discussion
BEN_FAWKES
Jun 17, 2019Copper Contributor
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 ...
BEN_FAWKES
Jun 17, 2019Copper Contributor
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...
Wyn Hopkins
Jun 17, 2019MVP
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
- BEN_FAWKESMar 07, 2020Copper ContributorWyn 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?- Mar 08, 2020Hi BEN_FAWKES, Please check the solution posted. https://techcommunity.microsoft.com/t5/excel/pilot-logbook/m-p/1215928 Regards, Faraz Shaikh 
- Wyn HopkinsMar 08, 2020MVP