+ 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. 03-01-2021, 05:05 PM #1
    Fraser1605
    Fraser1605 is offline
    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
    Reply With QuoteRegister To Reply
  2. 03-01-2021, 07:02 PM #2
    maras_mak
    maras_mak is offline
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    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.
    Reply With QuoteRegister To Reply
  3. 03-02-2021, 10:04 AM #3
    Fraser1605
    Fraser1605 is offline
    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.
    Reply With QuoteRegister To Reply
  4. 03-02-2021, 01:18 PM #4
    maras_mak
    maras_mak is offline
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Copying multiple rows from 5 sheets into 1 sheet based on certain criteria!
    By JMSisto in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1