is this possible?

[jhahes]

Could someone please help me or tell me if I can do the following.

I have this in a worksheet

Column A (name of item)

Fiesta 9 oz
Fiesta 4 oz
Fiesta 3 oz
Fiesta 1.5 oz

Column B (number of mixes scheduled of item)

6
5
4
10

Say in column B5 I have a total = it is the sum of A1:A4 which would be equal to
25 in this example

I want to create a userform that asks the user to input how many cases were made in total. If the user says 25, then I want it to delete all the number of mixes in A1:A4 and not do anything with the total field. However this is my dilema, if the user puts in 24 tubs made, I would like it to go through and erase all the tubs in A1:A4 and put the 1 (remaining number) in any of the cells (A1:A4). The only problem is that I have hundreds of mixes so I can't just say put in A4. I know how to do the code for everything except for leaving the remaining mixes.

If anybody could help or give me some better ideas, or logic in going about this, I would be extremely greatful. Thanks
Josh

[Colin Vicary]

OK, let's start with the logic.

If the user enters a different number than is the total then you want Excel to do something - that's easy enough.

The question is, what do you want Excel to do?

If the variable relates to the number or size of tubs, then you could use Vlookup.

EG if the difference between the total and what the user entered is one(as in your example) you could have a table that says

1= Fiesta 9oz
2= Fiesta 9oz + Fiesta 4oz

and so on.

Or did I miss the point by a mile?!

Colin