naming the last 3 rows so they can be easily changesd

[teri_carlson]

ok - so im trying to find a way to freeze or name the bottom 3 rows of each worksheet because they are identical and i want to be able to change threm all at once by typing the information into the Index Sheet the problem is that the work sheets are not the same size. say in sheet1 there are 6 rows between the top and the bottom 3 rows sheet2 there might be 16 sheet3 there might be 25 rows... is there any way to take those 3 rows and make them as sort of a permenent footer so tha

 

[hatman]

Umm, why couldn't you simply setting each cell equal to the cell that should be the source of the data? The number of used rows in your worksheets should not matter...