Pivots or VLookups or both

Occasional Visitor

Capture.PNGI have a file from a client.  They have asked me to see if I can automate pulling data for two different plants, and in each plant I need numbers for two different types of products... and I need the report to show one day at a time, updated daily and only 7 days (or more) in the future.  

I have an excel file that they are manually putting data into, but I dont even know if this is the best way to present the data. I have been reaching out to friends and family.. trying to bribe who ever I can to see if they can help, and so far, its beyond what anyone that I can reach knows how to do.  I have been trying to watch videos but nothing seems to be giving me the information that I want.  

Do I use Pivot tables? Do I do Vlookups? Can I use both?  How do I do this with so much filtered information.  

Below is the report they are asking me to fill.  (not sure how to get a better shot in this post).

I have the base data too.

 

Is there someone to help me? 

 MONDAYTUESDAYWEDNESDAYTHURSDAYFRIDAY
TORFLEXSPRUNGTORFLEXSPRUNGTORFLEXSPRUNGTORFLEXSPRUNGTORFLEXSPRUNG
4/4/20224/5/20224/6/20224/7/20224/8/2022
WEEK 4-861
60
      63281161250
      11827634588
 TOTAL      T= 181S= 557T= 506S= 338
 4/11/20224/12/20224/13/20224/14/20224/15/2022
WEEK 11-1561
60
6313910490509114176550436218
8225801391785041874711897233
 TOTALT= 885S= 719T= 149S= 668T=1013S= 301T= 647S= 739T= 508S= 251
 4/18/20224/19/20224/20/20224/21/20224/22/2022
WEEK 18-2261
60
17145534191500155841358333
450291533296331646122800
 TOTALT= 621S= 746T=567S= 487T= 533S= 31T= 519S= 641T= 58S= 333
 4/25/20224/26/20224/27/20224/28/20224/29/2022
WEEK 25-2961
61
78912798840120417850436333
102337126450621018109114217666
 TOTALT= 622S= 747T=568S= 488T= 534S= 32T= 520S= 642T= 59S= 334
0 Replies