+ Reply to Thread
Results 1 to 2 of 2

Building a table based on a smaller one

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Building a table based on a smaller one

    I have a table (AnnualPurchase). I have sources in rows, and years in columns.
    I solve an optimization model that determines how much I should buy from each source. The results will be output in another table, but the point is since I'm not buying from all of my sources, the supplier column is shorter than the original list.
    I want to write a code that creates Table 2, based on Table 1.


    Table 1
    1 2
    1 30 40
    3 20
    5 25


    Table 2
    1 2
    1 30 40
    2
    3 20
    4
    5 25

    I have writtten a very basic code, which doesn't work!
    Please Login or Register  to view this content.
    Any comment is appreciated

  2. #2
    Registered User
    Join Date
    06-11-2013
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Building a table based on a smaller one

    Update: The code works, the problem was my "Purchase_table" range. I should have included the index row and column in that too!
    I'm not sure if this is the best way to code it, but it works!

+ 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. Replies: 1
    Last Post: 02-03-2013, 09:05 AM
  2. Displaying large table into smaller table
    By FlynHokie in forum Excel General
    Replies: 3
    Last Post: 12-08-2012, 10:49 AM
  3. Building a table automatically based on data from another sheet (vlookup?)
    By HyperG in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-20-2012, 11:34 PM
  4. Filtering data from one large table into many smaller ones based on certain criteria.
    By hugedomer11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-11-2010, 12:57 AM
  5. Replies: 1
    Last Post: 09-21-2008, 01:36 PM

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