+ Reply to Thread
Results 1 to 4 of 4

Macro to bring back rows from multiple sheets to one master sheet based on criteria

  1. #1
    Registered User
    Join Date
    03-01-2021
    Location
    UK
    MS-Off Ver
    2019
    Posts
    2

    Macro to bring back rows from multiple sheets to one master sheet based on criteria

    Hi All,

    My Macro experience is incredibly limited and I'm struggling to even find tutorials that can help me with this request.

    Regarding the spreadsheet attached in this thread...

    I wish to copy all the rows that span sheets "Building Wide" all the way to "Floor 8" that contains the word "open" in column N to be copied over to the sheet titled "Outstanding"

    Could anyone help me with this or even let me know if it is possible? :').
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    470

    Re: Macro to bring back rows from multiple sheets to one master sheet based on criteria

    I think this does what you want.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best Regards,
    Maras.

  3. #3
    Registered User
    Join Date
    03-01-2021
    Location
    UK
    MS-Off Ver
    2019
    Posts
    2

    Re: Macro to bring back rows from multiple sheets to one master sheet based on criteria

    Thank you so much!!!

    One day maybe I'll be able to write a code like that haha.

  4. #4
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    470

    Re: Macro to bring back rows from multiple sheets to one master sheet based on criteria

    Glad to help. Can you please mark as solved.

+ 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. [SOLVED] bring data from multiple sheets to one sheet based on name sheets
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2020, 05:27 PM
  2. Replies: 3
    Last Post: 07-18-2015, 02:06 PM
  3. [SOLVED] Create new sheets from master sheet based on multiple column criteria
    By hamidxa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2015, 02:44 PM
  4. [SOLVED] URGENT - Match Criteria and bring back multiple rows
    By Keelin in forum Excel General
    Replies: 2
    Last Post: 12-10-2014, 12:06 AM
  5. [SOLVED] Bring back a name in one column based on criteria in 2 other columns
    By BillDoor in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-22-2013, 08:07 AM
  6. Macro to Transfer data from multiple sheets into rows on a master sheet
    By serrone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2013, 06:35 AM
  7. Copy rows from master sheet to other sheets based on criteria
    By spikeysas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2011, 04:28 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