Currency transaction record

[annadinesh]

Dear Experts

I want a table in which the No of Currency received/given to be record in a cell

like for 1000 Note

1000 4
500
200
100
.
.

if i receive 1 note of 1000 rupee then i write 1 in front of 1000 rupee cell
if i receive another 1000 rupee note then i write 2 in front of 1000 rupee note
if i give 1 1000 rupee to someone the i have to write 1 in front of 1000 rupee note

all the time i need to write the no of transaction to be done with the note.

now i want a vba code to record the no of transaction for the particular note

like when i double click on the cell it should show me 1+1-1

hope you understand my query

Please help



Regards

Dinesh Saha
9932022569

 

[Crystalyzer]

how are you entering the number of notes?

if you double click the cell should the number of notes be increased or decreased? by how much?