Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
how can I connect data in cell C to data in cell D? | Charts and Charting in Excel | |||
ranking query | Excel Discussion (Misc queries) | |||
Cell data format | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |