Dynamic Maximum Value for Scrollbar (Form)

[joetogo]

Hi team,

I'm trying to set a max limit on my Form Scrollbars (I have 4 unique named scrollbars on sheet "dash_v2").

I have COUNTIFS formulas (in cells) on sheet "dash_v1" calculating total references, i.e. 2 of this, 31 of that etc...
Those references are the numbers I'd like to use as a maximum scroll limit on the bars on "dash_v2"

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Sheet "dash_v1"

The COUNTIFS formula is below:
=COUNTIFS(table!$A$1:$A$69,control!$A$6,table!$D$1:$D$69,"Mobile")

The OFFSET formula is below:
=OFFSET(control!E2:E40,control!$C$2,0,1,1)

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Sheet "dash_v2"

4 x Scroll bars (Form)
I'm using "=CELLREF" to pull data from dash_v1 without having to enter formulas i.e. Total's (countifs) and Offset (scrollable data)

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Can anybody please help?

I've seen some solutions including vba but mainly where all the data and references reside in a single sheet. Can anybody please
help?

Thanks in advance.