I think this may be a pretty tough one, and if I need to move this over to macros, please let me know. But if this process can be streamlined, it'll help not only me but my whole department. I've got some description below, but I have attached a document that shows my goal.
I have two sets of data. First is the Style Plan, which has colors and prices of an object we will be selling this season, and the other is all colors and prices that object comes in. For example, this season we may just be selling Black and Purple Orchid Jackets at 89.50, but my source data will also contain the Fuschia Jacket we used to sell at 69.83.
Ultimate goal: My task is to verify that the prices in the style plan are correct.
I need a formula or macro that will say "I have #785617 AND color Blue Jay. My price is supposed to be $89.50. Let me search in this result for #785617 AND color Blue Jay and see if the price is indeed $89.50. If not, let me change the color so I'll notice."
The hard part though is my report data won't have the color Blue Jay as a separate column. It will have a description which contains the phrase Blue Jay, like "Windbrake Thermal Fleece Ja, Blue Jay, M". Also, my Style Plan will just have Blue Jay once, but my report data will return it in all the sizes it comes in (Blue Jay, M; Blue Jay, XL).
Here's what you'll find in the example I've attached.
I've listed the data from my Style Plan as three columns on one tab called "Style Plan". Then on the tab "SAP Data" I've included all of the Article Data from the report I generated. The leftmost column, Style #, I created using a =left( command to pull out the style number for easier matching. The "Article Description" column is where you have to go to search for the color data to match from the style plan.
Again, if I need to ask this in another section, please advise. Thanks for your help.
Bookmarks