Antsmarching.org Forums - Dave Matthews Band Discussion - View Single Post - Roger’s Excel Thread
Thread: Roger’s Excel Thread
View Single Post
Old 06-15-2017, 12:35 PM   #199
rconverse
 
rconverse's Avatar
 
Join Date: May 2003
Location: Pretty Boy Blue State
Posts: 77,945

Shows Seen: 25

DMB Hub Stubs: 14

My Tour Central Stats

Re: Excel Help
Quote:
Originally Posted by Arby View Post
Did a google search, but Im not really finding specifically what Im looking for.

Anyone here know how to do Freeze Panes on multiple sections? So...what Im looking for is rows 1-6 to be frozen. Easy enough.

But then when I scroll down to row 474, I want 474-479 to take the place of the first freeze. They are similar headlines, so rows 1-6 can fall out of view and 474-479 will replace as the frozen section.

Then this same scenario actually needs to happen one more time with rows 947-952.

Any help is appreciated!
Why do you have multiple column headings in the same columns? Makes no sense.

Okay, that said, the only way to do this is with a macro. Is that okay?
rconverse is offline   Reply With Quote