BobbyConkers
New Member
- Joined
- Mar 26, 2014
- Messages
- 33
Good morning all.
I am looking for a solution whereby a different top row is displayed depending on where the user is scrolled down to in a tab. This is for display purposes only.
I have columns A-S populated not with data, but with graph and narrative tiles.
The header (just cells A1:S1, merged, sorry, not my fault!) for the first section is "Harm Free Care". Obviously I could freeze this pane at A2. However, once one scrolls down to row 241, the relevant header would become "Patient Experience" (cells A240:S240). Once down to row 377, the top visible row would become "Patient Outcomes" (cells A376:S376).
Is there way of changing the visible top row (or header?) depending on where one is scrolled to in the sheet please? VBA would be fine.
Many thanks in advance,
Andy
I am looking for a solution whereby a different top row is displayed depending on where the user is scrolled down to in a tab. This is for display purposes only.
I have columns A-S populated not with data, but with graph and narrative tiles.
The header (just cells A1:S1, merged, sorry, not my fault!) for the first section is "Harm Free Care". Obviously I could freeze this pane at A2. However, once one scrolls down to row 241, the relevant header would become "Patient Experience" (cells A240:S240). Once down to row 377, the top visible row would become "Patient Outcomes" (cells A376:S376).
Is there way of changing the visible top row (or header?) depending on where one is scrolled to in the sheet please? VBA would be fine.
Many thanks in advance,
Andy