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

G

Guest

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I combine data (not consolidate) from separate tabs to one? 2
How do I combine these columns into one? 2
HOW DO I COMBINE two spreadsheets into one by names in column a 3
HOW DO I COMBINE DATA FROM MULTIPLE ROW INTO ONE ROW AND ADD VALUE 3
How do I combine many worsheets into one worksheet?? 6
how do i combine data from multiple sheets into one sheet? 3
how do I combine 2 excell documents to make one... 1
copy from one sheet to another workbook 2

Top