Need help using a SPC tool

[gum-boss]

I'm using a set of calipers linked to a PC via the keyboard port. Data is
recorded when you press a button on the calipers to a SPC spreadsheet I made
in Excel. After inputting data in 15 columns I'd like the cell pointer to go
to the first of the 15 colums on the next row automatically. Any
suggestions?

Thanks in advance!
Mike

 

[Jerry W. Lewis]

You could try something like the code posted at

http://groups.google.com/groups?selm=3F0BFCFF.2060509@no_e-mail.com

Jerrry

 

[Arnie]

One very simple solution is to highlight the range in which you wish
to enter your values by clicking and dragging. As an example, if you
highlight A1 to O8 you will notice that the range is darkened except
for A1. Each time you key a number and press the Tab key the active
cell will move one cell to the right. Once a value has been entered
in cell O1 the active cell will become A2. The values will remain
within the constrained highlighted area. Should you wish to enter the
values by row use the enter key rather than the tab key.

You may want a more automated solution than this, but it's a start.

Arnie

 

[gum-boss]

Thanks, Jerry, for the link. One of the macros worked perfectly!
Mike

You could try something like the code posted at

http://groups.google.com/groups?selm=3F0BFCFF.2060509@no_e-mail.com

Jerrry