Sleeper: Locate and copy from database to another worksheet

[coliervile]

Good afternoon everyone. I want to thank everyone that have posted different VBA's thus far that have helped me on my quest. I'm a new member and a true novice at VBA.

I have an Excel 2000 database that track employees requesting vacation/leave requests. On one sheet, named "Leave Request" all employees request go in this database and looks like this:

NameRequestedTypeStartEndAA22-May-06Prime Time1-Jun-064-Jun-06


What I want to do is to look-up all request of one emploee (e.g. "AA") in the data base and copy all of their leave request results to another sheet called "AA Request" and the format of this sheet is exactly the same as above. I would also like to do the same except that I want to use each day of the year and the results would render all employees that requested time-off that day and put the results in a sheet named "Day to Day.

Thanks for you help.

Charlie

[lenze]

You can do this with Advanced Filter or best (IMO) MSQuery. A Pivot Table might also fit your needs. Can you attach a sample file of your data?

lenze

[coliervile]

Thanks for your reply. I've tried the Advanced Filters, but it doesn't update when new data is added. Here's what I've got thus far:

[coliervile]

?The upload keeps failing- can I email it to you?

[lenze]

?The upload keeps failing- can I email it to you?

Sure. Put the word Excel in the subject line to bypass my filter

lenze

[coliervile]

I tried it but it still fails?????

[lucas]

zip it up and post it here.....might have better luck

[coliervile]

Let's try this- I tried but my file is to big to transfer.

[lucas]

duplicate threads deleted.
did you get my pm? coliervile?

[lucas]

Attached is a copy of the file coliervile is working on with everything stripped out except what he/she is working on.....

Once others can see what your trying to do maybe you can get some specific help.

Password stuff has been removed.

[lenze]

Look at the Pivot Table in this attachment. I think it gives you the information you are seeking.

lenze