Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is this possible?
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 -- jhahes ------------------------------------------------------------------------ jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596 View this thread: http://www.excelforum.com/showthread...hreadid=390759 |