tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,210
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Hope someone can help me.
I want to be able the have a macro scroll the page to a name.
Now heres my page set up
Columns A to H are fixed using freeze Panes,
I onwards are the columns with names in,
The name I want to scroll to is in cell B5 (as in this is where the name is stored to look for)
the names are listed in row 8
So I need a macro that can look at the name in cell B5, go along Columns I to CA
find a matching name and scroll that column so it sits next to my frozen cells, so next to H.
can someone help me do this please?
Thanks
Tony
Hope someone can help me.
I want to be able the have a macro scroll the page to a name.
Now heres my page set up
Columns A to H are fixed using freeze Panes,
I onwards are the columns with names in,
The name I want to scroll to is in cell B5 (as in this is where the name is stored to look for)
the names are listed in row 8
So I need a macro that can look at the name in cell B5, go along Columns I to CA
find a matching name and scroll that column so it sits next to my frozen cells, so next to H.
can someone help me do this please?
Thanks
Tony