Extract Specific Data from one Worksheet to Another Automatically

Note: This will be a shared, protected Excel 2010 file so unfortunately macro is not an option.

I have really deleted out a lot of the other data in my real file to create the example. My existing file has about 15 other columns and 1000s of rows. What I am trying to achieve, is a way to automatically create a cover sheet document on tab 2 based off of the data already being input on tab 1 for a specific set of criteria.

Anything that is forwarded to Legal on today's date (or a particular date) - I want to pull over the fields on tab 2 automatically from tab 1 as opposed to filtering, copy, and pasting or manually entering the data a second time.

I know I've read some articles on VLOOKUP perhaps being able to assist me but I'm not sure how I could leverage that here since I'm not looking for a count due a specific data field. I know as long as I can somehow get the file number to pullover automatically, I could use an INDEX MATCH function to pull over some of the remaining fields.

Help please! If macro or Access is the only way then I guess I'll just have to settle on a copy paste situation.

On tab Files To Legal, paste in A2 :

Please Login or Register  to view this content.

Drag over to F2, then all six columns down.


A different approach, paste this into the Files To Legal sheet level module:

Please Login or Register  to view this content.

Thank you Logit but won't this just copy over the same data without extracting the specific data I want which is anything Labeled as Legal in the last column - Forwarded To: and preferably today's date in the Forwarded Date column?

My apologies, I missed that in your first post.

Give this a try. did you work at 914/107th ?

That's queuesef, that seems to do the trick except for only pulling items based on today's date but I think I can potentially figure that one out on my own.