Need to copy information from one sheet to another based on date.

[taylorsm]

I have a report. Picture One sheet with six tables, four columns each. Each dedicated to an employee. Columns are Date/Category/Type/Name. Each day they add their previous days activities. I then go in every morning and copy the previous days and email just that day off to my manager.

Since production varies it isn't as easy just just selecting rows 10-20. I need to be able to input the date I am querying (or just do the previous workday) and have it sweep each employee's table and copy it over to a new sheet so I can simply send that sheet on. Attached is a fair representation of what I am looking for.

Is this something that can be done? since it is done only once a day, I don't really want to bog down my sheet with an array.

[AlphaFrog]

This could be done with simple formulas.

See the attached file. Change the date in AA2 to what you want in the report.

[taylorsm]

Thanks. Is there a way to populate the AE Date list? instead of requiring me to insert the current date? Sorry, seems like such a minor thing when you've already made it so easy for me

[AlphaFrog]

The AE date list lists the last nine days and automatically updates. You could make the list longer or shorter if you want. Otherwise, I don't understand what you're asking.

You can also type in any date in AA2

[taylorsm]

AH, gotcha sorry I completely misread the formula. No that will be perfect.