Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |