Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Petty Cash book
Hi,
I tried to create a Petty Cash Book in Excel. The format is this __________________________________________________ ______________________ A B C D E F __________________________________________________ ______________________ From 01/01/2006 to 03/07/2006 __________________________________________________ ______________________ Balance 388.82 __________________________________________________ ______________________ Date Receipt No. Description Received By Deposit Withdrawn __________________________________________________ ______________________ 01/01/2006 1011 Deposit to petty cash 500.00 03/01/2006 243 Lunch for overtime workers Akash 18.53 03/01/2006 243 Lunch for overtime workers 18.53 03/01/2006 243 Lunch for overtime workers 18.53 03/01/2006 243 Lunch for overtime workers 18.53 03/01/2006 243 Lunch for overtime workers 18.53 03/07/2006 243 Lunch for overtime workers 18.53 __________________________________________________ ______________________ Totals Rs. 500. Rs. 111.18 I have a Coulm Date starting from A6:A50 In the Cell Number A3 i want the Out Put as" From Min Date to maximum Date " So I used the below mentioned formulae to get the desired result. "From "&TEXT(MIN(A6:A50),"dd/mm/yyyy")&" to "&TEXT(MAX(A6:A50),"dd/mm/yyyy") I want a macro through which I dont have to put the the above mentioned formulae in A3 Cell. More over i want that as soon as the user feels that he has enter sufficient amount of details in Sheet1 and presses a shortcut key then a new sheet with the name of current date should activate with with the below mentioned format. __________________________________________________ ______________________ A B C D E F __________________________________________________ ______________________ From 01/01/2006 to 01/01/2006 __________________________________________________ ______________________ Balance 388.82 __________________________________________________ ______________________ Date Receipt No. Description Received By Deposit Withdrawn __________________________________________________ ______________________ 01/01/2006 1011 Deposit to petty cash 388.82 __________________________________________________ ______________________ Totals Rs. 388.82. Rs. Is this possible. Please Do help me in this regards Akash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PETTY CASH | Excel Worksheet Functions | |||
Petty Cash Controller | Excel Discussion (Misc queries) | |||
Petty Cash Log Help | Excel Worksheet Functions | |||
petty cash report | Excel Discussion (Misc queries) | |||
I need a petty cash template. can anyone help me? | Excel Discussion (Misc queries) |