Home

Logbook Entry at top - new row required

%3CLINGO-SUB%20id%3D%22lingo-sub-695838%22%20slang%3D%22en-US%22%3ELogbook%20Entry%20at%20top%20-%20new%20row%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695838%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20recently%20wrote%20a%20pilot%20logbook%20with%20TOTALS%20formulas%20myself%2C%20and%20the%20flight%20entries%20are%20in%20row%20chronological%20order%2C%20with%20the%20latest%2Fnewest%20entry%20at%20the%20top%20of%20the%20spreadsheet.%26nbsp%3B%20How%20do%20I%20get%20the%20spread%20sheet%20to%20automatically%20produce%20a%20new%20line%20at%20the%20top%20of%20the%20spreadsheet%20as%20I%20am%20filling%20in%20the%20last%20flight%20details%2C%20dready%20for%20the%20next%20flight%20details%20please%3F%3C%2FP%3E%3CP%3EThanks...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-695838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-695866%22%20slang%3D%22en-US%22%3ERe%3A%20Logbook%20Entry%20at%20top%20-%20new%20row%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695866%22%20slang%3D%22en-US%22%3EYou%20would%20have%20to%20add%20VBA%20(Macro)%20to%20automatically%20add%20a%20new%20row.%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20a%20practical%20alternative%20I'd%20suggest%20turning%20your%20table%20of%20data%20into%20a%20Table%20using%20Ctrl%20T%20and%20then%20whenever%20you%20want%20to%20add%20a%20new%20row%20just%20Right%20Click%20on%20the%20first%20row%20and%20choose%20Insert%20%26gt%3B%20Table%20Rows%20Above%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-695870%22%20slang%3D%22en-US%22%3ERe%3A%20Logbook%20Entry%20at%20top%20-%20new%20row%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695870%22%20slang%3D%22en-US%22%3EHi.%20Thanks.%20I%20know%20how%20to%20inert%20rows%20but%20I%20thought%20there%20might%20be%20a%20neat%20solution%20that%20XL%20could%20automatically%20add%20another%20row%20above%20the%20row%20that%E2%80%99s%20having%20data%20inputted%2C%20ready%20for%20the%20next%20row%20of%20data%20above...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-695883%22%20slang%3D%22en-US%22%3ERe%3A%20Logbook%20Entry%20at%20top%20-%20new%20row%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695883%22%20slang%3D%22en-US%22%3ENo%20sorry%2C%20the%20best%20you're%20going%20to%20get%20is%20a%20one%20click%20solution%20with%20VBA%20so%20it's%20not%20really%20worth%20it%20given%20the%20built%20in%202%20click%20solution%20with%20Tables%3C%2FLINGO-BODY%3E
BEN_FAWKES
Occasional Contributor

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

3 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
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies