Need macro to populate spreadsheet based on cross referencing of tabs

Instructions are also within the attached.

Need to bring "Table" volume into "Master" highlighted column. I do not have material on "Table" so it's hard to do. I need a formula/macro that breaks down the promo volume from "Table" down to material level for "Master." Only way to do this is by looking at LY Volume.

Please see Zone EE & Promo 50745 on "Master" for example. 715,452 is the Sept total for EE/50745 on "total" tab. I broke that number down to the materials listed on "Master" tab by inputting a formula. I don't have time to do this for every single promo combination. Is there a macro or a better formula that involves lookups so I can do this in a quick manner??

Let me know with any questions or suggestions, thanks.

so I may be wrong in looking at this but im trying an advanced filter to filter your "table" data based on the cells im looking at in your master sheet to reference the zone and promo number and ive got a system that works but everytime I tell vba to remove the filter to go the next time excel crashed I think based on the shear amount of data provided in the table sheet, im still new to vba so I may be looking at this the wrong way though

Feel free to cut the data in half. If you have a macro that works, I can probably edit it or run it on different data sets to accommodate my large file needs.

So far I've cut all the data off "table " into new worksheets each named with the zone letters. Just trying to write one to incorporate all the formulas with a counter due to the more then one product numbers

On both sheets, insert a new column before all other columns, col A
In cell A2, enter the formula =B2&"_"&C2 and copy down. Repeat for 2nd sheet.
Enter the following formula into cell F2 of sheet Master, and copy down:

=IF($E2<>0,E2/SUMIF($A:$A,$A2,$E:$E)*IFERROR(VLOOKUP($A2,Table!$A:$I,6,FALSE),0),0)

cyiangou - Need macro to populate spreadsheet based on cross referencing of tabs.xlsb
Does this help?

I appreciate your response. Your formula was close but the calculations were just a hair off on some! It worked on some of the smaller combinations but not all. I
chose one as example on what the numbers should tie out to. Please see attachment for that scenario. thanks

Sorry - try this formula:

=IF($E2<>0,$E2/SUMIF($A:$A,$A2,$E:$E)*SUMIF(Table!$A:$A,$A2,Table!$F:$F),0)

awesome work. Thanks so much!!