ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combining data from 2 worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/77977-combining-data-2-worksheets.html)

naulerich

Combining data from 2 worksheets
 
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!



All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com