Dynamic Table with scrollbar using Offset function

[joyhampton]

Hello,

I've been stumped for a couple of days now. I'm VERY new to VBA (Youtube'd taught) and I'm creating a dashboard. I'm stumped on my first table...

Here is what I'm trying to Accomplish: (This is a recruiting activity dashboard)
Table of all "Active" Reqs. (Rows will increase daily) with only 4 out of 30 columns.
Keep this table in a 10row long box on the dash board.


What I have already done:
created an advanced filter from the raw data to capture only the active reqs.
Created an offset function on the dashboard sheet
Use a form control scrollbar to move the rows

Problem:
I can get it to work when I know exactly how long the range will be,
but that range will increase daily. How can I get the offset function to work so that it doesn't show "0"'s for blanks?
Or can I do this in VBA? How?

Thanks for your help!!

[AlKey]

The Max value should be the count of all rows, including header row minus number of rows in the table. Since the data will change, the number of rows will increase. Therefore you need select a cell that will show the total number of rows e.g =COUNTA(C:C)-10. Now, make a right click on the sheet and select View Code. There you will see two lines of code. Now inter between these tow lines following code

Please Login or Register  to view this content.

Make sure the ScrollBar name is the same and the Range("B") refers to the cell on there worksheet where you have COUNTA formula.