How do I create a summary page from multiple worksheets

G

Guest

Trying to roll-up information from multiple worksheets within the same
workbook to a summary page. These worksheets are copies of each other. For
example: each worksheet has a column labeled "defect number". The users can
record multiple defect numbers within a cell (e.g. 897, 992, 1001)

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

How do I (or can I) rollup this information to a summary page where sheet5
is the summary worksheet and row1 = 897, 990, 992, 995, 1001, 1012.
Here's what I have so far
[=State1!$H$3:$H$51&State2!$H$3:$H$51...etc]

of course this creates a text string where the numbers display like this
[89799099299510011012]
 
J

JulieD

Hi

see my answer to the post by alemcgm on exactly the same topic ... just
wondering if it's homework ???

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

combining data from multiple worksheets 2
creating a table from twenty worksheets 3
Transferring data from multiple worksheets to a Summary sheet 2
Linking multiple worksheets in one workbook 2
Combing Info. from multiple worksheets 2
Copying Cells From Multiple Worksheets to Create Summary Sheet 1
Relative worksheet reference for multiple worksheets in a workbook 5
How do I lookup data from multiple worksheets? 2

Top