Hello there everyone,
I have a sheet that is going to be an order form, it contains product codes, barcodes, product descriptions, prices, RRPs etc, with a lot of different products with a lot of different headings for each category etc. I would like the headers of each category to float on the row just below the frozen panes i already have at the top containing the info headings when scrolling down, until the next header is reached, at which point the header for the new section you're just about to scroll through will replace the one from the previous section. (Is everyone still with me here?)
I've tried selecting multiple rows and freezing the panes but that seems to select the highest up header and freeze that one only. Please note i do know what the freeze panes functionality is, i already have a couple frozen and that's not exactly what i'm after, essentially i want certain rows to be frozen at the top depending on which rows are visible to the user.
Could something like a looping macro be used to continuously unfreeze and freeze panes depending on which row is at the top of the page?
I have a sheet that is going to be an order form, it contains product codes, barcodes, product descriptions, prices, RRPs etc, with a lot of different products with a lot of different headings for each category etc. I would like the headers of each category to float on the row just below the frozen panes i already have at the top containing the info headings when scrolling down, until the next header is reached, at which point the header for the new section you're just about to scroll through will replace the one from the previous section. (Is everyone still with me here?)
I've tried selecting multiple rows and freezing the panes but that seems to select the highest up header and freeze that one only. Please note i do know what the freeze panes functionality is, i already have a couple frozen and that's not exactly what i'm after, essentially i want certain rows to be frozen at the top depending on which rows are visible to the user.
Could something like a looping macro be used to continuously unfreeze and freeze panes depending on which row is at the top of the page?
