Populate spreadsheet based on cross referencing of tabs.

**eguirocker3** · 07-09-2015, 02:09 PM

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 formula 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. See Zone EE & Promo 50745 on "Master" for example. I need formula or macro to save a ton of time.

Let me know with any suggestions, thanks.

**FDibbins** · 07-09-2015, 02:17 PM

Where do you get those values from?

The only EE/50745 I can find has a volume on 715452, not 392892?

**eguirocker3** · 07-09-2015, 02:22 PM

The 715,452 is the Sept total for EE/50745 on "total" tab. I need to break that number down for the materials listed on "Master" tab for EE/50745. Using LY volume I'm able to do this.