When I am missing some input information for column D of each row in Sheet1
of my spreadsheet, I need to mark(or name) the current cell in column D
Sheet1 so I can jump to cell C7 in Sheet2 to do some separate calculations
for Sheet1 and then jump back to the marked cell in Sheet1 and copy the value
(with no formating) from Sheet2 cell C27.
I have worked all evening and I have not been able to accomplish this. Any
ideas would be appreciated...

Hi Harlen,

One suggestion:

When in column D in sheet1, (say cell D10):

F5 | D10 | Enter

Do your calculation on sheet2, then:

F5 | select D10 (the first dialog entry) | Enter


---
Regards,
Norman



"Harlen" wrote in message
...
When I am missing some input information for column D of each row in
Sheet1
of my spreadsheet, I need to mark(or name) the current cell in column D
Sheet1 so I can jump to cell C7 in Sheet2 to do some separate calculations
for Sheet1 and then jump back to the marked cell in Sheet1 and copy the
value
(with no formating) from Sheet2 cell C27.
I have worked all evening and I have not been able to accomplish this. Any
ideas would be appreciated...

Hi Harlen,

Thinking again: if you leave sheet1 (without taking *any* special marking
precations), perform your calculations on sheet2 and then re-select sheet1,
will you not, automatically, return to the D column cell you left?

Also, if this is a VBA question, the issue should not arise because it
should be unnecessary to jump between sheets or even to select either sheet.


---
Regards,
Norman



"Harlen" wrote in message
...
When I am missing some input information for column D of each row in
Sheet1
of my spreadsheet, I need to mark(or name) the current cell in column D
Sheet1 so I can jump to cell C7 in Sheet2 to do some separate calculations
for Sheet1 and then jump back to the marked cell in Sheet1 and copy the
value
(with no formating) from Sheet2 cell C27.
I have worked all evening and I have not been able to accomplish this. Any
ideas would be appreciated...

By using a macro (or VBA) I would like to be able give the current (or
active) cell a tempory name and automatically move to the new calculation
area. Then after I am finished the calculations, I want a macro to take me
back to the previously named cell and also copy the results of my
calculations to that cell.

The only cell reference procedures I can find in VBA is an "absolute"
reference and a "relative" reference. I need to make a variable type
reference to the "current" cell. Does this make any sense?

"Norman Jones" wrote:

Hi Harlen,

Thinking again: if you leave sheet1 (without taking *any* special marking
precations), perform your calculations on sheet2 and then re-select sheet1,
will you not, automatically, return to the D column cell you left?

Also, if this is a VBA question, the issue should not arise because it
should be unnecessary to jump between sheets or even to select either sheet.


---
Regards,
Norman



"Harlen" wrote in message
...
When I am missing some input information for column D of each row in
Sheet1
of my spreadsheet, I need to mark(or name) the current cell in column D
Sheet1 so I can jump to cell C7 in Sheet2 to do some separate calculations
for Sheet1 and then jump back to the marked cell in Sheet1 and copy the
value
(with no formating) from Sheet2 cell C27.
I have worked all evening and I have not been able to accomplish this. Any
ideas would be appreciated...

Hi Harlen,

If you use VBA, there should be no need to make any selections: missing
values on sheet1 can be replaced using calculations from (or based on)
sheet2 values, all without either sheet being selected.

If instead you explain the steps necessary to replace the missing values, I
am sure that group participants will be able to assist you.

If, notwithstanding the above, you feel it necessary to manually jump
between sheets, did my last suggestion for that not satisfy your needs?


---
Regards,
Norman



"Harlen" wrote in message
...
By using a macro (or VBA) I would like to be able give the current (or
active) cell a tempory name and automatically move to the new calculation
area. Then after I am finished the calculations, I want a macro to take me
back to the previously named cell and also copy the results of my
calculations to that cell.

The only cell reference procedures I can find in VBA is an "absolute"
reference and a "relative" reference. I need to make a variable type
reference to the "current" cell. Does this make any sense?

"Norman Jones" wrote:

Hi Harlen,

Thinking again: if you leave sheet1 (without taking *any* special
marking
precations), perform your calculations on sheet2 and then re-select
sheet1,
will you not, automatically, return to the D column cell you left?

Also, if this is a VBA question, the issue should not arise because it
should be unnecessary to jump between sheets or even to select either
sheet.


---
Regards,
Norman



"Harlen" wrote in message
...
When I am missing some input information for column D of each row in
Sheet1
of my spreadsheet, I need to mark(or name) the current cell in column D
Sheet1 so I can jump to cell C7 in Sheet2 to do some separate
calculations
for Sheet1 and then jump back to the marked cell in Sheet1 and copy the
value
(with no formating) from Sheet2 cell C27.
I have worked all evening and I have not been able to accomplish this.
Any
ideas would be appreciated...