The following steps need to be put into an Excel spreadsheet

profiletutor4helpyou
data.xls

Sheet1

Historical Customer Demand
Part Number Part Description Supplier Lead Time (months) Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 Oct-09
25216-12277 Vlookup Wrench Set Macros Plus 2.5 1680 1800 480 840 1200 360 600 1200 360 600 480 1920 1560 1680 1800 840 1320 840 1200 840 1920 480

Sheet2

Sheet3