I'm working with my downloaded order guide. Our old ordering program was replaced with a "new and exciting" way to order. Problem is, there was no inventory program associated, and no on took the time to think about it. I found a way to download my order guide into an excel format. I could easily type in my quantity on hand, but here's the catch. Under pack count, it says case. Under Unit pack size, it says
In an easy world I could do.
Price/unit size (12)*amount on hand=cost on hand
then I can copy that all the way down, sum it up, and be done with it. BUT NO! I am 95% done creating this for the company. I need a way to turn "12/case" into 12. Easy enoungh If(cell)="12/case",12,0....but there are muliple pack counts ....1,6,12,24....etc.
Smitty, you are with out a doubt the friggin king. This forum in general is one of the best I have ever seen as far as communication goes. You should all be very proud of what you do, and never stop doing it!