How do I combine filtered data from one worksheet to another?
 

I have a filtered report with a list of employees which contains their
department, title, and Yes/No skillset columns (report1). The other filtered
report is a list of all the projects each employee has submitted for the last
6months (report2). Report2 has each employee listed multiple times based on
how many projects submitted. I need to combine the Yes/No skillset columns
from report1 into report 2. Allowing me to analyze the skill sets per
project submitted.

How can I do this without having to go line by line?
--
Thanks
DB

How do I combine filtered data from one worksheet to another?
 

P.S. My worksheets columns look like this:

Report 1: Employee name, dept, title, Editing skill (yes or no), Accounting
(yes or no), Management (yes or no)

Report 2: Employee Name, Project Date, Project Name etc..

I need to join the two reports together. I need exel to read the names and
apply the appropriate data from report 1 onto each rows in report 2.
--
Thanks
DB


"DenverBuddafly" wrote:

I have a filtered report with a list of employees which contains their
department, title, and Yes/No skillset columns (report1). The other filtered
report is a list of all the projects each employee has submitted for the last
6months (report2). Report2 has each employee listed multiple times based on
how many projects submitted. I need to combine the Yes/No skillset columns
from report1 into report 2. Allowing me to analyze the skill sets per
project submitted.

How can I do this without having to go line by line?
--
Thanks
DB