Going to particular column based on selection

[Dak!]

I have selected the range with mouse say A2:A5 and after selecting I click check, then I want z2:z5 to be true

TIA

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Dak!]

It worked. Thanks John

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.

[Dak!]

I have one more query. Shall I open a new thread for that?

Anyway, I go to last used row for column C and then go to next row column A and insert a check box and link that to same row z column

[JOHN H. DAVIS]

Yes. That would be a new thread.

[Dak!]

Thank you John