+ Reply to Thread
Results 1 to 4 of 4

advanced formula help, cannot fill a table from many other tables per certain criteria

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    advanced formula help, cannot fill a table from many other tables per certain criteria

    I have a multiple table workbook and I need to fill one of the tables with data from all of the other tables when the other tables have more than 11 rows filled.
    I have attached a workbook with the tables in it. All the data is sensitive so I had to remove all the data. The actual data doesn't matter in this situation just if there are more than 11 rows of data in each table. The amount of actual data in each table will change each time the workbook is started so that must be taken into account. The tables full sizes are A1:V200.

    The 'Extra' table is the table that needs to be filled from tables, 7, 8, 9, 10, 11, 12, 1, 2, 3.
    Please post code examples with your replies.
    Thanks!
    Attached Files Attached Files
    Last edited by derrickh13; 02-19-2013 at 02:10 PM. Reason: change title

  2. #2
    Registered User
    Join Date
    02-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: advanced formula help, cannot fill a table from many other tables per certain criteria

    Can this be accomplished using an index statement?

  3. #3
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: advanced formula help, cannot fill a table from many other tables per certain criteria

    so what exactly do you want?
    rows in the other tables a above the 11th moved to the new table?, and will the old tables keep getting data added to them?
    do you want the data from the old tables grouped, or does it matter?, is there some sort of layout for how the extra rows get added to the new table?

    a couple of examples of what you would like to see in the new table would be of immense help
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  4. #4
    Registered User
    Join Date
    02-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: advanced formula help, cannot fill a table from many other tables per certain criteria

    Edited:
    I have made the request simpler.
    I need to combine the data in tables '8' and '9' where the row number exceeds 11. I need this combined data to fill the 'Extras' table.
    If it is possible to combine array values from different tables I should be able to figure out how to combine the rest of the data I require.

    The attached sample has sample data. The cells in red in the '8' and '9' tables needs to be combined and shown in the cells in red in the 'Extras' table. In real operation the amount of data in these tables will very.

    Original
    The 'Extras' table needs to show all the data in each column for each row past the eleventh row from all the other tables (so rows 12-200).
    Would like all the data grouped together so the 'Other' table shows all the data sequentially starting with row A2, row A1 will be the header. So, potentially, the 'Extras' table could have roughly 1700 rows if all the other tables ever get completely filled, which will realistically never happen.

    The finished project will be run like a report and will only be run once at the end of the day, the data will change day to day but I don't think the data will be changing while the report is open. The actual data is being pulled from tables that are connected to a database that get updated when the project is started so all the data will be automatically added when the tables are updated with the database.

    Thanks
    Attached Files Attached Files
    Last edited by derrickh13; 02-20-2013 at 11:12 AM. Reason: change in data

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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