Problem with linking offset function and reference table

This is my first post, so please bear with me.

I have a master table with all of my entered data. Using the offset function, I created a smaller table that I can scroll through by adding a scroll bar to the area with the offset functions. Everything works correctly UNTIL I add another row to the top of the master table. The cells containing the offset functions lose their reference to the master table cells.

Ex.

Row Column B
19 =offset($B$,37,$A$1,0) where $A$1 is a reference to the added scroll bar.
20 =offset($B$,38,$A$1,0)
21 =offset($B$,39,$A$1,0)
22 =offset($B$,40,$A$1,0)

My table runs from B37:I1017. B37 is the header row. When I add a row to the table, creating a new 38 row, the offset function disappears in cell B19 leaving me with values of


19 =offset($B$,37,$A$1,0)
20 =offset($B$,39,$A$1,0)
21 =offset($B$,40,$A$1,0)
22 =offset($B$,41,$A$1,0)

Is there a function or workaround I can use to avoid having to format the cells every time I add a row? I am using the worksheet as a financial ledger, and will be adding new rows weekly.

Any help would be greatly appreciated. I hope my description makes sense!

Matt

Hi Matt,

This sounds like you used a Dynamic Named Range to solve your question. If not, they are VERY cool. See them at:
http://www.bettersolutions.com/excel...G820716330.htm or
http://www.ozgrid.com/Excel/DynamicRanges.htm

Also - if you problem is solved, you should edit your first post and change the prefix of the title to "Solved", so people know you've got an answer.