Problems with scrolling tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2573355%22%20slang%3D%22en-US%22%3EProblems%20with%20scrolling%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2573355%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20please%20I%20need%20some%20help%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20create%20a%20Scrolling%20Table%2C%20I%20use%20the%20offset%20function%20to%20generate%2Fshow%20the%20info%20on%20the%20table%2C%20and%20it%20works%20perfectly%2C%20it%20shows%20the%20data%20from%20the%20source%20in%20the%20way%20that%20is%20supposed%20to%20be...%3C%2FP%3E%3CP%3EBut%20the%20problem%20starts%20when%20I%20Insert%20a%20new%20Line%20of%20data%20on%20the%20source%2C%20then%2C%20it%20doesn't%20show%20me%20the%20new%20information%2C%20there%20is%20something%20else%20that%20I%20have%20to%20do%3F%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20answers%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2573355%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2573902%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20scrolling%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2573902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1109606%22%20target%3D%22_blank%22%3E%40Georgepc22%3C%2FA%3E%26nbsp%3BI%20found%20an%20example%20on%20line%20that%20uses%20a%20scroll%20bar%20and%20OFFSET.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.bluepecantraining.com%2Fcreate-a-scrolling-table-in-excel%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.bluepecantraining.com%2Fcreate-a-scrolling-table-in-excel%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20probably%20what%20you%20are%20trying%20to%20use%20as%20well.%20Since%20you%20mention%20to%20have%20Office365%2C%20use%20a%20structured%20table%20in%20combination%20with%20a%20spinner%20(or%20scroll%20bar)%20and%20the%20FILTER%20function.%20Then%2C%20the%20filtered%20data%20range%20will%20expand%20automatically%20and%20you%20don't%20get%20the%20zero's%20like%20when%20using%20the%20OFFSET%20function%20when%20you%20set%20the%20maximum%20number%20beyond%20the%20current%20size%20of%20the%20data%20set.%20See%20attached%2C%20in%20Sheet1.%20The%20other%20sheets%20are%20from%20the%20on-line%20source.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, please I need some help here.

 

When I create a Scrolling Table, I use the offset function to generate/show the info on the table, and it works perfectly, it shows the data from the source in the way that is supposed to be...

But the problem starts when I Insert a new Line of data on the source, then, it doesn't show me the new information, there is something else that I have to do?

Thank you for the answers 

2 Replies

@Georgepc22 I found an example on line that uses a scroll bar and OFFSET.

https://www.bluepecantraining.com/create-a-scrolling-table-in-excel/ 

 

That's probably what you are trying to use as well. Since you mention to have Office365, use a structured table in combination with a spinner (or scroll bar) and the FILTER function. Then, the filtered data range will expand automatically and you don't get the zero's like when using the OFFSET function when you set the maximum number beyond the current size of the data set. See attached, in Sheet1. The other sheets are from the on-line source.

Thank you Mr. Riny van Eekelen, helps a lot working with the structured table. the FILTER function is very good too.