Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I link data in three different cells? ck# date amount
I am trying to balance a checking account in excel. I want to keep three
cells linked to one another, for example check #, Date, and amount from a registery and then link the comparison to the banks check # while leaving those three information linked together. For example Banks cleared date, cleared amount, and cleared check number. I also want the register to adjust information to match to the bank statement and show a difference between the two amounts into a new cell. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I link data in three different cells? ck# date amount
This might get you started
Ck # Date Amount String 1234 12/31/2008 100.00 1234 12/31/08 100.00 the string formula is =A2&" "&TEXT(B2,"mm/dd/yy")&" "&TEXT(C2,"##0.00") -- Tom "Shiela" wrote: I am trying to balance a checking account in excel. I want to keep three cells linked to one another, for example check #, Date, and amount from a registery and then link the comparison to the banks check # while leaving those three information linked together. For example Banks cleared date, cleared amount, and cleared check number. I also want the register to adjust information to match to the bank statement and show a difference between the two amounts into a new cell. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I link data in three different cells? ck# date amount
This might get you started
Ck # Date Amount String 1234 12/31/2008 100.00 1234 12/31/08 100.00 the string formula =A2&" "&TEXT(B2,"mm/dd/yy")&" "&TEXT(C2,"##0.00") -- Tom "Shiela" wrote: I am trying to balance a checking account in excel. I want to keep three cells linked to one another, for example check #, Date, and amount from a registery and then link the comparison to the banks check # while leaving those three information linked together. For example Banks cleared date, cleared amount, and cleared check number. I also want the register to adjust information to match to the bank statement and show a difference between the two amounts into a new cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link cells to pull specific data | Excel Worksheet Functions | |||
macro Excel problem link cells with Data-Validation option | Excel Discussion (Misc queries) | |||
link with date to data worksheet | Excel Worksheet Functions | |||
How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
Put same data in cells on two different worksheets (link?) | Setting up and Configuration of Excel |