Set up the view according to ..

[madocar]

Hello everyone,

I want to ask you her help. There is a long table consist of 53 weeks. If I want to see only week of 38 I have scroll lot more. And there is my question: Is there any way how to switch my view according the input. When I put number the number to B7 I want to see that week. More in attachment.

Thanks a lot for any help

 

[Somendra Misra]

Hi,

See this file.

Regards,

 

[madocar]

Thanks a lot Somendra Misra
I can not see the macro code though.
When I moved the cell B7 it stopped working. Probably need to adjust the code

 

[Somendra Misra]

@madocar

The code is on worksheet modules.

Regards,