Hi,
I am creating a spead sheet to divide a number over a few rows of colums which will either input a colour or the number its been divided by... i.e 2 (every number will always be divided by 2, as the cost is £2). So if some one pays £10 the sum=10/2=5, so 5 boxes would be filled green. Also if that person pays another £6 it will fill the next three boxes (sum=6/2=3) not the same boxes that have been done before. So im think i will need a formula or fuction for each person as they each have there own row. So an input box and button might be needed aswell.
Any help been pointed in the right direction, or will this need VB?
I excel.jpg
Thanks Phil
Bookmarks