One criteria in multiple columns

Hi everyone,

I am in the process of making an overall planner for me and my team.
I want to have an overall sheet that displays all tasks, but I then want separate sheets for each week (e.g. week3, week4, week5 etc.)

The planner is set up as shown in the picture attached
example.PNG

So for instance for week 3, I want a macro that looks in column E-I for "x" and returns only those with an "x". This result should be copied to a new sheet and the rows returned should only include column A-I

My issue is how I get the macro to look for a single criteria across multiple columns. I have searched online, but haven't found a solution that fits this! Does anyone know how this can be solved?

Hi and welcome.

Could you attach a sample workbook (not a picture of one) and show us what your expected output looks like?

BSB

Hi,

Thanks very much!

And yes sure. I have just tried to set up an example with random input.
The wanted output is those in sheets called: Week 3, week 4 and week 5 - this output should be returned from overall sheet

Attachment 767460

Originally Posted by BadlySpelledBuoy

Hi and welcome.

Could you attach a sample workbook (not a picture of one) and show us what your expected output looks like?

BSB

Let me know if more info is needed then the attached file from my previous reply 😊

The attachment doesn't work. Follow the instructions in the yellow banner at the top of the page to attach a file.

BSB

Oh, I am so sorry! I hope I did it correctly now