I receive a weekly Stock Level Report(SLR) at my workplace. This report
has data from 7 different warehouses and the rows (and once a month the
columns) move around constantly.

I created a Date Code report, in which the user enters a SKU and it
looks up what the product is, how long its good for, how many
cases/pallet, etc. I'm trying to link each SKU on my data list to the
Stock level report, to show Weekly sales, and total units.

The original plan was to do a simple look up, which worked perfectly...
until I got a new SLR, and none of the weekly sales matched up. I have
limited knowledge of Excel, and programming in general.

Does anyone have any sugestions?


--
mbachurski
------------------------------------------------------------------------
mbachurski's Profile: http://www.excelforum.com/member.php...o&userid=30812
View this thread: http://www.excelforum.com/showthread...hreadid=504776