On Jul 1, 11:37*am, Kanmi wrote:
Master!. i know this is hard to understand what I'm trying to do but I will
appreciate your taught and help to solve this. My humble pleasure to you all.

I have a large two workbook *(destination.xls and source.xls), that track
training of employee. The source.xls is link to the database such a way that
whenever i open, it *pull Automatic update from the database. Manager has
list of employee under him that have undergone the training and these names
sometimes occur more than one time because they have two or more training..
*I am trying to set up way that after update pulled by source.xls from the
database should Automatically copies to Destination.xls on a particular rows
and also only pick one name at a time if they appear more than one time"maybe
pick the first occured of each name" and cordinate the name by Manager. * For
example *

"SOURCE.XLS"
* * * * * *A * * * * * * * * * *B * * * * * * C * * * * * * * * * * * * D
A1 * *EMPLOYEE * * * * *ID * * * *COURSE NAME * * MANAGER
* * * *Kim Bell * * * * * * *002 * * *Sales Training * * * * Brian
* * * *Kim Bell * * * * * * *002 * * *Safety Training * * * *Brian
* * * *Lee Paul * * * * * * 003 * * *Light Training * * * * *Mark
* * * *Lee Paul * * * * * * 003 * * *Sales Training * * * * Mark.
"DESTINATION.XLS"

* * * * * * B * * * * * * * * * *C * * * * * * * *D * * * * * * * * * * * * *

B11 * MANAGER * * EMPLOYEE * * * * ID
* * * * BRIAN * * * * * *Kim Bell * * * * * 002
* * * * MARK * * * * * * Lee Paul * * * * *003

I mean the names should appear on the destination.xls automatically
according to thier MANAGER and each name should appear once on the
destination.xls "sheet1" even if new staff data pulled from database to
source.xls. *
The COURSE NAME ROW is neccesary but it can be scrap out if it will prevent
us to achieve what we want. * *

Please your taught and help will be much more welcome and appreciate your
time. Thank you and look forward to *hear from you.

*Was this post helpful ?

Kanmi,

Have you tried a pivot table or data filter yet?

Best,

Matthew Herbert