Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting the Check Register Balance to show on another Sheet
I have been trying to figure this out for a while. My boss has multiple check
registers on my computer and they are sheet 2,3,4,and 5 on my check register work book. My boss wants sheet one to display all their balances. Is their anyway to make it automatically update with out have to copy and paste them each time I balance them. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting the Check Register Balance to show on another Sheet
Hi!
If these are "typical" check registers then the balance is usually the last (used) cell in the right most column. So, you can use a lookup formula for each balance: Assume the balance is in the last (used) cell in column G of each sheet: =LOOKUP(MAX(Sheet2!G:G)+1,Sheet2!G:G) Or: =LOOKUP(9.99999999999999E+307,Sheet2!G:G) Biff "thenderson" (donotspam ) wrote in message ... I have been trying to figure this out for a while. My boss has multiple check registers on my computer and they are sheet 2,3,4,and 5 on my check register work book. My boss wants sheet one to display all their balances. Is their anyway to make it automatically update with out have to copy and paste them each time I balance them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create a running balance on checkbook register | Excel Discussion (Misc queries) | |||
can i register a digit in excell sheet cell | Excel Discussion (Misc queries) | |||
how : check register running balance is a stationary cell | Excel Discussion (Misc queries) | |||
Where are instructions for using Check Register template in Excel. | Excel Discussion (Misc queries) | |||
Values in 'Balance sheet' template are in $ I want £ but there is. | Excel Discussion (Misc queries) |