How to generate report on rows from multiple worksheets where column has particular text


New Member
Feb 26, 2016
HELP!! I've been struggling for a few days with this issue now and although i've come across a few different examples which i think sound similar to what i need my to worksheet to do, given that i'm pretty much a complete novice at VBA, i cant work out how to adapt the examples i've found to suit my issue. My issue is this:

I basically have 3 separate worksheets (Team 1, Team 2 & Team 3) which have the same column headers which are: 'Grade', 'Trade', 'Employee No', 'Surname', ' Forename/s', 'Shift', 'Number of courses present', 'All essentials present', 'Percentage against grade', 'Essentials not present', 'Additionals', and 'Essentials required for grade' which are in row 1 of columns A to L respectively. There is then also a separate 'report tab' within the same workbook.

What i want is to have two buttons on the 'report' tab which i can assign a macro to each, which will effectively produce a report by filtering column 'H' in each of the three team sheets to just the entries which have the text "No" in them, and copy them over to the 'report' sheet. Likewise i would like a separate button which does the same for the entries with "yes" in column 'H'. However, due to the document being updated regularly, i would like the buttons to perform the action of updating the data, so if for example one of the entries goes from a "No" to a "Yes" in column 'H' then, upon clicking the button again, the information will update and that entry will be located under the correct report.

I hope i've explained as best as possible, any help with coding if necessary or any other solution for that matter would be hugely appreciated.



Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).


New Member
Sep 12, 2015
Hi Liam,

To me it would be simpler to have all teams in the one sheet. Just insert a column for the Team Number.

Then you can just filter on Team Number and column H with Yes or No etc.


Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...