Create a scrolling table in excel. no VBA !

I'm going to show you how to create a scrolling table in excel.

You just need 2 scroll bars that's it. Of course you sample/real data. :)

Follow the steps mentioned below.

1). Create 3 sheet(or rename the existing one). "Report", "Staging and Lookup" and "Source_Data."

2). Place 2 scroll bar (form control) in Report sheet as shown in image below.

3).  Right click on horizontal scroll bar control and select "Format Control..".
4).  Now you will have to give a cell link to this control.Give it to cell B2 in "Staging and Lookup" sheet. Shown in image below.

5).  Follow the above steps 3rd and 4th step for vertical scorll bar.  Give cell link to cell B3 in "Staging and Lookup" sheet.

6). Now its time to create a staging table(see image below).  I have created a table to display 5 columns(0-4) and 8(0-7) rows of data. You can increase or decrease the number of rows and columns depending on your table requirement.

  7). Its time to put some formula now. Put your row no. formula as shown below, copy the same formula till end..

8). Put formula as shown below for column no. and copy the same formula till end.

9).Put some data in "Source_Data" sheet and name the entire data range as "Data_Table".

10). Come back to "Staging and Lookup" sheet. Use offset function to populate data for display. If you want row data to be static on horizontal scrollbar click, use stating index(column G) else use dynamic index (column H). Same goes for columns data.

Click for a sample of workbook