I have been trying it get data to roll up from cell A20 to B1. As you enter
information and get to A20 have Excel automatically skip to B1. For people
that are familiar SolidWorks it uses an Excel spreadsheet for its design
tables. When the table is then inserted into a drawing the information from
these cells runs off of the print. If this will skip from cell to cell this
would cure this problem for me.

Thanks