Combining data from 2 worksheets

N

naulerich

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!
 
Top