Extract correct denomination of bills, money counter, remove large bills,

I need help in extracting the largest bills from avaialble bills to get a set total. I am trying to create atemplate to remove the largest bills from all the avaialble bills.
In the case below, I want to extract exactly $$1,178.29 in largest available bills from a register which has $1328.29 . THis will leave the reigter with $150 exactly in change every time


3 $100.00 $300.00
3 $100.00 $300.00
$50.00 $0.00
31 $20.00 $620.00
3 $10.00 $30.00
7 $5.00 $35.00
2 $1.00 $2.00
16 $0.25 $4.00
1 $0.10 $0.10
23 $0.05 $1.15
4 $0.01 $0.04
2 $10.00 $20.00
2 $5.00 $10.00
2 $2.00 $4.00
4 $0.50 $2.00
$1,328.29



$150.00
$1,178.29

I think you need 2nd largest number from a range, then =LARGE(A1:A100,2)

150


2929.94 2779.94 0

hand remove remain
helper row 0
bill 100 6 #VALUE!
tens 100 10
fives 100 10
bill 50 3
bill 20 1
bill 10 3
QR 10 4
Bill 5 5
DR 5 8
NR 2 8
Bill 1 3
PR 0.5 8
qaurter 0.25 4
Dimes 0.1 4
Nickel 0.05 9
Pennies 0.01 9

Something is wrong in cell F10 and down...I get a #value ofr MIN (D10, int(....))

remove-money(1)-does-not-work.xls

remove money.xlsxdoes not work..

Thanks...I'm going to try it out..
.Again, thanks a lot !

It does not quiet work. It is removing money that is not there !
Thanks
Rama

Thanks again..What does the helper row do?

Thanks for the help in the money denomination.
Now, I am trying to hide the sheets with only the right user having access to see (hide and unhide) their sheet. The manger should have access to the entire workbook. All with user name and password protection.
I do not want anyone to be able to see the code. Can you please help me that. I really appreciate it.
See attached file...Total deposits to be viewed by Manager/Admin only. Niraj can only see and work on his sheet, Umer can only see and work on his sheet etc
Can the passwords be encrypted?
Thanks for all your help

Can somebody please look at my file. I am not too familiar with VB and I am not sure it is working quite right. I need usernames and passwords, whereby only the admin/manager has access to the entire sheet. The others should only have accessto view/work on their sheets. On save the sheet should hide. On open it should show an empty sheet.