+ Reply to Thread
Results 1 to 4 of 4

Pull data from sheets and combine in first sheet based on specific value in one cell

  1. #1
    Registered User
    Join Date
    01-27-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    2

    Pull data from sheets and combine in first sheet based on specific value in one cell

    Afternoon all,

    I'm hoping i can get some help with this problem.

    I have a spreadsheet with 5 sheets. The first sheet needs to be a combination of the other 4 tabs. The last 4 tabs are managed by individuals and only specific rows from each ones are required on the first tab.

    Basically if column L has "Active" typed into it, it needs to be added to the front sheet dynamically. As the number of rows required to be copied to tab 1 will constantly be changing, they need to be added dynamically, rather than using a formula which will designate a certain cell or row to the data from a specific cell or row from a specific sheet.

    I am desperate for help on this one as i have been trawling google etc and have found some macros or VB scripts but unfortunately, as i dont understand any of it i have no reference points to try to kind reverse engineer them.

    Your help is most appreciated and i have attached an example of the workbook i am using.

    Many, many thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Pull data from sheets and combine in first sheet based on specific value in one cell

    attached find the workbook with a macro to consolidate the data into ACTIVE

    The macro assumes that the Active Tab is in the first position.
    It also adds a "*" on the 13th column to mark a posted entry

    cheers,
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-27-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Pull data from sheets and combine in first sheet based on specific value in one cell

    You are an absolute LEGEND. Thanks you so so much!

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Pull data from sheets and combine in first sheet based on specific value in one cell

    glad to be of help.

+ Reply to Thread

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