Scroll Bar

[Groadie65456]

Hi All,

Just wondering if I could get some help.

I have created a type of gantt chart with an input box and scroll bar to sheet. The scroll bar has Format Control on cell G2.

What I am after is to see if its possible to set the Week # based on value in G2.

E.g. If I move the slider to 2 or update the input box (cell G2) = 2, it essentially sets G4 to be week: 2
Or If I set cell G2 = 3, it essentially sets G4 to be week: 3

Not sure I am explaining myself clearly.

Thanks in advance!

 

[Georgiboy]

I think i would make the formula in cell G4:
=G2

Then you can make the other week cell formulae:
=G4+1
=N4+1
etc.