PDA

View Full Version : Sleeper: Locate and copy from database to another worksheet


coliervile
05-22-2006, 02:19 PM
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
05-22-2006, 02:28 PM
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
05-22-2006, 03:00 PM
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
05-22-2006, 03:17 PM
?The upload keeps failing- can I email it to you?
lenze
05-22-2006, 06:13 PM
?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
05-23-2006, 07:06 AM
I tried it but it still fails?????
lucas
05-23-2006, 07:11 AM
zip it up and post it here.....might have better luck
coliervile
05-23-2006, 07:51 AM
Let's try this- I tried but my file is to big to transfer.
lucas
05-23-2006, 08:04 AM
duplicate threads deleted.
did you get my pm? coliervile?
lucas
05-23-2006, 09:17 AM
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
05-23-2006, 10:44 AM
Look at the Pivot Table in this attachment. I think it gives you the information you are seeking.

lenze