combining data from multiple worksheets

G

Guest

I am trying to combine data from multiple worksheets within the same
workbook. I have 5 worksheets that are exact copies of each other. One
clolumn is labeled "defect numbers". User are able to record multiple defect
numbers within each row. Example

sheet1, row1 = 897, 990
sheet2, row1 = 995
sheet3, row1 = 998, 1001, 1012
sheet4, row1 = empty

Worksheet 5 is the summary sheet where I would like to display all the data
from sheets 1-4 on the form like this:

Sheet5, row1 = 897, 990, 995, 998, 1001, 1012

Here's what I have tried so far
=State1!$H$3:$H$51&State2!$H$3:$H$51

Of course this lists the data in a text string like this
Sheet5, row1 = 89799099599810011012
 
J

JulieD

Hi

one option is
=Sheet1!H3& ", " & Sheet2!H3 & ", " & Sheet3!H3 & ", " & Sheet4!H3
and fill down as needed

Cheers
JulieD
 

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 create a summary page from multiple worksheets 1
Excel 2013 Merge Data 2
creating a table from twenty worksheets 3
delete row off 5 worksheets containing specific value 8
Combining data from multiple worksheets. 7
Combining same data in multiple rows 4
chart with data source from multiple worksheets 2
Transferring data from multiple worksheets to a Summary sheet 2

Top