MR1984

Items Month Wk 10 Wk 11 Wk 12 Wk 13   Current Week Item 1 Item 2 Item 3 Item 12
Item 1 Mar 110 210 310 1210   Demand
Item 1 Apr 120 220 320 1220   Mar        
Item 1 May 130 230 330 1230   Apr        
Item 1 Jun 140 240 340 1240   May        
Item 1 Jul 150 250 350 1250   Jun        
Item 1 Aug 160 260 360 1260   Jul        
Item 1 Sep 170 270 370 1270   Aug        
Item 1 Oct 180 280 380 1280   Sep        
Item 2 Mar 190 290 390 1290   Oct        
Item 2 Apr 200 300 400 1300            
Item 2 May 210 310 410 1310   What I want to do is get I3:L10, to auto-fill based on the week number in H1, and fill the appropriate column of the Item number in I1:L1.
Item 2 Jun 220 320 420 1320  
Item 2 Jul 230 330 430 1330  
Item 2 Aug 240 340 440 1340  
Item 2 Sep 250 350 450 1350  
Item 2 Oct 260 360 460 1360  

By: Cody Bailey

Leave a Reply

Your email address will not be published. Required fields are marked *