I am wanting to do 2 tables on one sheet and be able to keep the header of each table visible but scroll through the data in each table. I have found that you can insert a scroll bar for a table but all the data has to be pulled from a different area. This table is going to be used for information found through researching different areas.
I have attached a sample file. I would like to keep row 1 and 12 frozen and be able to have multiple lines (say 20-30) that I can add data into and scroll in between row 1 and 12 and also under row 12.
I hope this makes sense.
Thank you for your help.
Bookmarks