Scroll Bar with user defined increment / data

[nagovind]

Dear All,


There are 2 set of data


One set is in range A1:A10 other set is in B1:B10


I need to have a scroll bar with the data as in A1:A10 for each corresponding scroll bar data the corresponding cells in B cells has to be displayed


I have tried with Form controls scroll bar but the issue is increment is set as 1 my data is discrete hence the issue


Data in A1:A10 is 1, 2, 5, 6, 9, 12, 16, 19, 20, 21


Data in B1:B10 is aa,bb,ww,ss,gg,tt,ee,gg,kk,pp


For the scroll bar with continuous scrolling will have to result only the data in A1:A10 with respect to the linked cell data of B1:B10 can be displayed using INDEX formula


Please advise the method to do so


Thank you

 

[NARAYANK991]

Hi Govind ,


Can you give more details ?


What is supposed to be displayed when the scroll bar is moved from one end to the other in steps of 1 ?


Narayan