+ Reply to Thread
Results 1 to 2 of 2

Dynamic Sub Tables - One Master Many Outputs

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    10

    Dynamic Sub Tables - One Master Many Outputs

    Hello,

    I'm struggling to automate several worksheets that feed off a master worksheet - these are all within the same workbook

    MASTER --> WAREHOUSE COST (UK) + WAREHOUSE (FR) = LIST PRICE (UK) + LIST PRICE (FR)

    My two main suppliers are 'Adidas' and 'Nike'. I need the LIST PRICE to pick up which items are saleable based on the 'Sell From Country' in column J and transpose these onto the Warehouse Template. These in turn need to feed the appropriate List Price tabs

    I've tried experimenting with Dynamic Sub Tables to no avail. Ideally, i need these two suppliers split as per warehouse and presented in the List Price sheets with their appropriate Landed Cost Price.

    Please could you assist?!
    Many thanks,

    Jusmightbeokay
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Dynamic Sub Tables - One Master Many Outputs

    I would likely use a datatable to house the data, then pivot tables and formulas (and possibly VBA if you want it completely automated) to populate the 4 tabs the way you want them.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dynamic Sub Tables Based On Master Sheet Array formula & drilling through
    By pamela16 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-16-2019, 05:48 AM
  2. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-12-2013, 02:28 AM
  3. Replies: 4
    Last Post: 08-16-2013, 05:45 PM
  4. Replies: 2
    Last Post: 03-24-2011, 04:45 AM
  5. Replies: 0
    Last Post: 08-09-2010, 08:09 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1