Results 1 to 3 of 3

Create new table with data from multiple tables according to criteria

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2011
    Location
    Argentina
    MS-Off Ver
    Excel 2007
    Posts
    12

    Red face Create new table with data from multiple tables according to criteria

    Hi Guys,

    Monthly, I receive a file with multiple sheets on it (but with the same sort and format).
    This sheets contains expenses charged into multiple WBS (Cost Centres).
    I'm working on a project, who has specifics WBS (listed in a sheet called "WBS Needed".

    The challenge here is to retrieve those rows from the other sheets that meets the criteria of my list of "WBS Needed", and show, in a new worksheet, a new table just the expenses that corresponds to my project (or my WBS).

    Attached is my workbook for reference.

    The criteria key is WBS number, but I don't know how to list, on the a new sheet, those rows from different sheets that meets the criteria.
    (one below the other)

    Can be with a Macro maybe? or is there a formula that make things easier?

    Rows quantity may vary each month.

    Many thanks!

    Lean
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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