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