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

D

DenverBuddafly

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

DenverBuddafly

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
Compare two Workbooks and combine data into one workbook 0
How do I combine records from different sources 0
HOW DO I COMBINE two spreadsheets into one by names in column a 3
Linking data from one worksheet to another using ookup functions 2
How to combine data from 100 similar Excel files 2
HOW DO I COMBINE DATA FROM MULTIPLE ROW INTO ONE ROW AND ADD VALUE 3

Top