Logbook Entry at top - new row required

[BEN_FAWKES]

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

[#2]

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

[#3]

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

[#4]

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

[#5]

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

[#6]

Sounds like you need an INDEX MATCH Ben

https://accessanalytic.com.au/index-match/

[#7]

Hi @BEN_FAWKES,

Please check the solution posted.

https://techcommunity.microsoft.com/t5/excel/pilot-logbook/m-p/1215928

Regards, Faraz Shaikh