Xl file

Hello,

Hi,I need a help for my inventory sheet. I have to create a sheet as shown in summary.That sheet is picking data from Pivot table and that table is made from master sheet.I am using VLLOKUP to get the data in my summary sheet from pivot.The file is only showing some locations in sheet but in actual i have 70stores with 209phone models.So its really very hard to use Vlookup for this much data.I need a Macro or Sumproduct use in the sheet so that data can be automatically updated in the summary sheet as per location and model.The summary sheet should pick available quantity from in Stock column of Pivot and for weekly average it should multiply daily average with 7.This should be done for all stores automatically. thanks to all of you in advance..Looking forward for your support. The file can be viewed on shailendraisking.hpage.com,under introduction category with name pls help sample.


thanks once again
Regards,Shail