+ Reply to Thread
Results 1 to 2 of 2

How to Copy Rows from multiple sheets onto another that match certain criteria

  1. 07-30-2018, 07:45 PM #1
    zlongshot
    zlongshot is offline
    Registered User
    Join Date
    07-30-2018
    Location
    Coventry
    MS-Off Ver
    Windows 10
    Posts
    1

    How to Copy Rows from multiple sheets onto another that match certain criteria

    Hi all,

    Been looking around for a solution to my problem with no luck.
    I'm fairly new to VBA but I think... I know the basics.

    I am creating a Master spreadsheet for football results from the last couple of years.

    I need to create a macro for a button to search through multiple sheets and copying rows that match my search results into certain cells
    I have seen a few solutions for this around the web, however my problem is a bit more complex.

    First of all I need it to search for rows that contains both teams and both home and away games.
    Second of all I need to paste the row into a certain cells.

    I hope I am making sense here.

    Example.
    Sheet1 (Data) is where I want to paste the rows
    Sheet2 (Premier League) Contains all the matches and results from the past few years
    Sheet3 (Prem Tables) Contains The league tables as well as information about the referees
    I have 10 other sheets for the 5 other Leagues that contain the results and league tables.

    Cell B3 and C3 Both contain an identical drop down list of Premier League teams.

    I want the macro to match the 2 teams in these cells with any results in the Premier League sheet (Home Teams in Column C) (Away teams in Column E) and Copy The rows Into Cell A25 on the Data sheet

    I then need it to match the Team in Cell B3 of the Data sheet with any results in the Prem Tables Sheet and again copy rows and place in Cells A11-A16
    Then I need it to do the same for the team in Cell C3.

    Finally I need it to match the referee that is in D3 with the referees in Prem Tables Sheet and again... copy row and past into Cells H3-H8

    I will need it to do the same for all of the 5 other leagues

    Sorry for the long description. Hope you understand

    I have attached screenshots For you to look at
    Data Sheet.jpgPremier League.jpgPrem Tables Teams.jpgPrem Tables Referees.jpg
    Reply With QuoteRegister To Reply
  2. 07-31-2018, 01:52 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How to Copy Rows from multiple sheets onto another that match certain criteria

    zlongshot, welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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] VBA Copy and Paste on criteria match through multiple sheets
    By ExcelKing424 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-06-2018, 06:44 AM
  2. Copy Rows from multiple sheets into one based on criteria
    By jh51745 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2016, 09:05 PM
  3. [SOLVED] Two criteria Index Match on multiple sheets returning multiple values
    By Joak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 10:03 AM
  4. [SOLVED] VBA Auto copy rows to multiple sheets by criteria
    By Freshlight in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-22-2014, 04:58 AM
  5. copy multiple rows that match 1 criteria to a new sheet that has different columns.
    By mozedd in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-13-2013, 07:06 PM
  6. Excel 2007 : if cell = criteria copy rows from multiple sheets to new sheet
    By dianavn in forum Excel General
    Replies: 1
    Last Post: 07-29-2011, 05:03 AM
  7. Match cells from Multiple sheets and copy rows
    By Kilcup01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2011, 12:43 PM

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