Help with Worksheet issue
 

Hello,

I was wondering anyone could help me solve this issue.

Description of wanting to accomplish €“

I have two worksheets first called €œAt a Glance€� and the Second called
€œCheck Register€� The €œCheck Register€� keeps running totals of your check book
so the cells and totals are always changing. What I would like to do is have
the €œAt a Glance€� worksheet cell C6 display what ever the last entry was in
your €œCheck Register€�. But since the cells change each time a new check is
entered I am not sure how I would go about doing this.

I currently have the following formula in the €œCheck Register€� worksheet in
Cells H6 down to H89 =IF(AND(ISBLANK(F6),ISBLANK(G6)),"",H5-F6+G6) This adds
or subtracts from the total. Of course the F and G and H change with each
cell as I go down.

Is there away to have the last entry I made in the €œCheck Register€� from
Cell Hx display in the €œAt a Glance€� worksheet under Cell C6?

Thanks
Scott

Help with Worksheet issue
 

Scott, put this in At a Glance cell C6 and see if it will work,

=INDEX('Check Register'!H:H,MATCH(9.99999999999999E+307,'Check
Register'!H:H))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Scott W" <Scott wrote in message
...
Hello,

I was wondering anyone could help me solve this issue.

Description of wanting to accomplish -

I have two worksheets first called "At a Glance" and the Second called
"Check Register" The "Check Register" keeps running totals of your check
book
so the cells and totals are always changing. What I would like to do is
have
the "At a Glance" worksheet cell C6 display what ever the last entry was
in
your "Check Register". But since the cells change each time a new check is
entered I am not sure how I would go about doing this.

I currently have the following formula in the "Check Register" worksheet
in
Cells H6 down to H89 =IF(AND(ISBLANK(F6),ISBLANK(G6)),"",H5-F6+G6) This
adds
or subtracts from the total. Of course the F and G and H change with each
cell as I go down.

Is there away to have the last entry I made in the "Check Register" from
Cell Hx display in the "At a Glance" worksheet under Cell C6?

Thanks
Scott

Help with Worksheet issue
 

Try this for numeric entries

=INDEX(H:H,MATCH(9.99999999999999E+307,H:H))

"Scott W" wrote:

Hello,

I was wondering anyone could help me solve this issue.

Description of wanting to accomplish €“

I have two worksheets first called €œAt a Glance€� and the Second called
€œCheck Register€� The €œCheck Register€� keeps running totals of your check book
so the cells and totals are always changing. What I would like to do is have
the €œAt a Glance€� worksheet cell C6 display what ever the last entry was in
your €œCheck Register€�. But since the cells change each time a new check is
entered I am not sure how I would go about doing this.

I currently have the following formula in the €œCheck Register€� worksheet in
Cells H6 down to H89 =IF(AND(ISBLANK(F6),ISBLANK(G6)),"",H5-F6+G6) This adds
or subtracts from the total. Of course the F and G and H change with each
cell as I go down.

Is there away to have the last entry I made in the €œCheck Register€� from
Cell Hx display in the €œAt a Glance€� worksheet under Cell C6?

Thanks
Scott

Help with Worksheet issue
 

Paul,

Thanks, that worked great!!!

Thanks again,
Scott

"Paul B" wrote:

Scott, put this in At a Glance cell C6 and see if it will work,

=INDEX('Check Register'!H:H,MATCH(9.99999999999999E+307,'Check
Register'!H:H))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Scott W" <Scott wrote in message
...
Hello,

I was wondering anyone could help me solve this issue.

Description of wanting to accomplish -

I have two worksheets first called "At a Glance" and the Second called
"Check Register" The "Check Register" keeps running totals of your check
book
so the cells and totals are always changing. What I would like to do is
have
the "At a Glance" worksheet cell C6 display what ever the last entry was
in
your "Check Register". But since the cells change each time a new check is
entered I am not sure how I would go about doing this.

I currently have the following formula in the "Check Register" worksheet
in
Cells H6 down to H89 =IF(AND(ISBLANK(F6),ISBLANK(G6)),"",H5-F6+G6) This
adds
or subtracts from the total. Of course the F and G and H change with each
cell as I go down.

Is there away to have the last entry I made in the "Check Register" from
Cell Hx display in the "At a Glance" worksheet under Cell C6?

Thanks
Scott

Help with Worksheet issue
 

Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Scott W" wrote in message
...
Paul,

Thanks, that worked great!!!

Thanks again,
Scott

"Paul B" wrote:

Scott, put this in At a Glance cell C6 and see if it will work,

=INDEX('Check Register'!H:H,MATCH(9.99999999999999E+307,'Check
Register'!H:H))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Scott W" <Scott wrote in message
...
Hello,

I was wondering anyone could help me solve this issue.

Description of wanting to accomplish -

I have two worksheets first called "At a Glance" and the Second called
"Check Register" The "Check Register" keeps running totals of your
check
book
so the cells and totals are always changing. What I would like to do is
have
the "At a Glance" worksheet cell C6 display what ever the last entry
was
in
your "Check Register". But since the cells change each time a new check
is
entered I am not sure how I would go about doing this.

I currently have the following formula in the "Check Register"
worksheet
in
Cells H6 down to H89 =IF(AND(ISBLANK(F6),ISBLANK(G6)),"",H5-F6+G6) This
adds
or subtracts from the total. Of course the F and G and H change with
each
cell as I go down.

Is there away to have the last entry I made in the "Check Register"
from
Cell Hx display in the "At a Glance" worksheet under Cell C6?

Thanks
Scott