Dear Sir, I created a MONTHLY ledger in Excel with Column 30 AND 31 rows.
#1 Column “E” has a labeled “code”.
In this row E1-31 I want to type “AT” for water bill “MCI”, “ELE” for telephone etc.
#2 Since I don’t know what row 1-31 these are going to fall at any given time I want
to type this codes “AT,MCI,ELE,
SW-BILL,FWM,HOME,CAR,CAP-ONE”
and have column “G” having the amount of the bill.
#3 Then I want column “G” is labeled “amount” having the (20.00) amount of the bill.
#4 Then I want column “M” labeled “At” show (20.00) amount for water bill.
#5 Column “N” will have “MCI” for telephone
and so on.
My question is can you give me the formula so when I type in “AT” the price
or amount It know to put the price inColumn “M” which is “AT” and also anywhere down that row.
There was a man who showed me this can be done but he has passed away and I
have lose the knowledge.
I can send you an attachment.
PS: It is a yearly page so I need to know how to pass this to the next ledger page. Maybe tied to the date.
FRANK
FFONTAN1@oncorgroup.com and ffbb@earthlink.ne