If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula required
Dera plz solve my problem, i m working in a bank my query is that
Today is 9-mar-10 my ending balance is 10,0000.00 in sheet 1 column A2 . and this balance automatically will insert sheet2 under (ENDING BALANCE) I want that next day on 10-MAR-10 my ending balance will that i will put in Sheet 1 coulmn (A2 )same coulm but in sheet 2 the balance of 9-mar-10 will not change and insert my ending balance of 10-mar-10 automatically will appear sheet2 on next Row. Plz give me formula. Note: Date will automatically chang in sheet1 with formula of =today() (SHEET 1) Date: 9-MAR-10 Today Ending Balance: 10,0000.00 (A2) (SHEET 2) DATE: ENDING BALANCE: 9-MAR-10 10,0000.00 10-MAR-10 11-MAR-10 |
Thread Tools | |
Display Modes | |
|
|