Combining data from 2 worksheets

G

Guest

I have 2 worksheets with the following data:

Worksheet 1---All Project (A1-A21)---Number of sites (B1-B21)
Worksheet 2---Customer Name (A1-A39)
then columns B-H have the All Project value if applicable.

I need to see:

project 1 number of sites customer1 customer 2 customer 3
project 2 number of sites customer14 customer 5 customer 1

Please help!
 

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

Scrabble Value calculation for Welsh words 0
matching & combining data from seperate worksheets 2
Copying data to summary sheet 2
identifying data from a separate worksheet 1
matching and entering data 3
Sumif, unique counts, 4
Concatenating results of Conditional statement 5
Excel Spreadsheet 3

Top