Quote:
Originally Posted by SteveDallas
Bwahahahahaha 
Sorry. There might be more efficient ways to store this info.. something to think about for the future....
It sounds like you fixed it, so good for you! But I'm still confused. What good does it do to nuke values from Column A if those rows still need to stay in, because you have different sizes and colors? |
A company puts out a quarterly CD with ALL frame information on it. I import the frames collections that I carry into my Point-Of-Sale application. That's the efficient part.
When I imported all the collections, I included frames that I do not have in stock (foolish, in hindsight), and colors and sizes that I don't have in stock. That way I can easily answer when a customer asks "does this frame come larger, in red?"
Now, I want to generate a list of only the name of the frames that I have in stock, but my POS doesn't provide that report. So I exported the entire inventory list to an excel file (46,000 + records). I've culled the list down to 7,662 unique frame names. All I have to do now is print 187 pages, check off the ones I have in stock, go into my POS and delete the ones I don't have in stock, and then go into each record and input the retail price of the frame. I show about 900 frames, usually 2 colors in each frame, so that's about 450 frames, average 3.2 colors and 2.6 sizes (total estimate). Only about 3,700 records to edit. Oy!
05-26-2010, 05:04 PM
Hybrid Mode
