roll data up from cell
 

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

roll data up from cell
 

I'm reading this question to be about cursor movement, and that when you
arrow downwards from A20 you arrive at B1.

This can be achieved by unlocking cells A1:B20 (or your desired block)
and then protecting the worksheet, ensuring the "select locked cells"
box is not checked


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=530022