Home

My Worksheet needs to have a blank second row to eliminate the need to scroll to the bottom

%3CLINGO-SUB%20id%3D%22lingo-sub-678178%22%20slang%3D%22en-US%22%3EMy%20Worksheet%20needs%20to%20have%20a%20blank%20second%20row%20to%20eliminate%20the%20need%20to%20scroll%20to%20the%20bottom%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678178%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EMy%20worksheet%20is%20a%20chronological%20data%20sheet%20with%20a%20lot%20of%20data.%20I%20would%20like%20it%20so%20that%20when%20data%20is%20entered%20it%20automatically%20shifts%20down%20one%20row.%20I%20know%20I%20could%20just%20insert%20another%20row%2C%20but%20this%20would%20be%20a%20slick%20functionality%20that%20would%20streamline%20my%20work.%20I've%20seen%20mentions%20of%20macros%2C%20etc.%20Would%20anyone%20be%20willing%20to%20help%20me%20with%20this%20script%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-678178%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678330%22%20slang%3D%22en-US%22%3ERe%3A%20My%20Worksheet%20needs%20to%20have%20a%20blank%20second%20row%20to%20eliminate%20the%20need%20to%20scroll%20to%20the%20bottom%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678330%22%20slang%3D%22en-US%22%3EHello%20there.%20We%20can%20help%2C%20but%20in%20order%20to%20do%20so%20we'd%20need%20to%20know%20your%20data%20structure%20and%20what%20specifically%20triggers%20the%20addition%20of%20a%20new%20row.%20Sample%20files%20help%20immensely.%3CBR%20%2F%3E%3CBR%20%2F%3EOut%20of%20curiosity%2C%20could%20you%20not%20go%20the%20other%20way%20with%20your%20data%20(top-down)%3F%3C%2FLINGO-BODY%3E
TWN579
Occasional Visitor

My worksheet is a chronological data sheet with a lot of data. I would like it so that when data is entered it automatically shifts down one row. I know I could just insert another row, but this would be a slick functionality that would streamline my work. I've seen mentions of macros, etc. Would anyone be willing to help me with this script?

1 Reply
Hello there. We can help, but in order to do so we'd need to know your data structure and what specifically triggers the addition of a new row. Sample files help immensely.

Out of curiosity, could you not go the other way with your data (top-down)?
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies