Making presence list

[helpmeplzush]

Hello, I am trying to make excel make me a list of my students based on the day.

For example:

I want excel to check who is here on Monday and show me the names in a list on "F"

 

[FDibbins]

You could probably just filter on the day you want to see?

 

[helpmeplzush]

You could probably just filter on the day you want to see?

Yes but i need it on another worksheet.

 

[FDibbins]

And Im guessing that "Monday" will change each day?

 

[helpmeplzush]

And Im guessing that "Monday" will change each day?

Yes please.

 

[mikerickson]

Advanced Filter should do what you want.

 

[helpmeplzush]

Advanced Filter should do what you want.

Can you explain please?

 

[mikerickson]

This will explain
https://support.office.com/en-us/ar...criteria-4c9222fe-8529-4cd7-a898-3f16abdff32b

 

[helpmeplzush]

This will explain
https://support.office.com/en-us/ar...criteria-4c9222fe-8529-4cd7-a898-3f16abdff32b

I didn't understand

 

[My Aswer Is This]

Maybe you could explain in words what you want.
Your image is very hard to see.
Like you said Monday

Will it always be Monday?

How will the script know what Day to look for?

And its hard to know what row to start looking on

Please say something like this:

When I enter Monday in Range("G14") search column E starting in row 12 for all cells with Monday in it and put these values in column F starting in row 12

Do not say look at my image.

I have blown my screen up to about 400 percent and still have a hard time seeing your image in detail

Tell us what column Monday is in like say Sun in column A Monday column B and on and on.

If you can provide these details maybe I can help you.