R
Roger on Excel
I have a spreadsheet for evaluating chemical processes.
The step numbers of the process descend in column A and the step's operation
adjacent to the step number in column B
I enter comments about various Operation steps in column R with the
appropriate step number in adjacent cell in column Q. At present I have to do
this manually which is tedious having to scroll over, enter the step number
and the comment. I also then make the operation cell yellow so I know that
step has a comment.
What I would like is to be able to click on one of the operation cells (in
column B) and then use a form button to cause the following to happen :
1) The step number of the operation is recorded (from the adjacent column A)
2) The step number entered into cell Q2
3) cell R2 selected so that I can enter a comment about the operation
4) a form button is pressed which returns the curser back to the operation
cell in column B and that cell is made yellow (or even better the comment
(from Q) is added to the comment dialog of that cell)
5) the cell below the origninally selected cell in column B is selected.
6) when I need to enter the next comment, it would return to the next free
cell in column Q and enter the appropriate step number and select the
adjacent free cell in column R for the next comment.
6) the return button takes me back to column B etc.. etc.
I know this sounds complicated, but can anyone help?
Best regards,
Roger Crump
The step numbers of the process descend in column A and the step's operation
adjacent to the step number in column B
I enter comments about various Operation steps in column R with the
appropriate step number in adjacent cell in column Q. At present I have to do
this manually which is tedious having to scroll over, enter the step number
and the comment. I also then make the operation cell yellow so I know that
step has a comment.
What I would like is to be able to click on one of the operation cells (in
column B) and then use a form button to cause the following to happen :
1) The step number of the operation is recorded (from the adjacent column A)
2) The step number entered into cell Q2
3) cell R2 selected so that I can enter a comment about the operation
4) a form button is pressed which returns the curser back to the operation
cell in column B and that cell is made yellow (or even better the comment
(from Q) is added to the comment dialog of that cell)
5) the cell below the origninally selected cell in column B is selected.
6) when I need to enter the next comment, it would return to the next free
cell in column Q and enter the appropriate step number and select the
adjacent free cell in column R for the next comment.
6) the return button takes me back to column B etc.. etc.
I know this sounds complicated, but can anyone help?
Best regards,
Roger Crump