Pull Data from Excel Worksheet to Another Based on Defined Values

**HjMcLean** · 12-12-2013, 07:07 PM

Sheet one is a summary page where all users enter data

data headers on all pages are: Bugzilla(PR) *SF(SR) Product *Color Opened Resolved Customer* Problem Description

Sheet two is a page where all data about a specific product type is gathered. There are 11 different products that will fall into this product type
Sheet three is another product page where another product type goes, 4 different products fall into this product type
Etc

I need a formula or macro to copy the data from the summary page based on the product and send the whole row to the specific product pages.
I am at my wits end trying to figure this out.

**vamosj** · 12-16-2013, 02:31 PM

While most can paint a pretty picture with just words, we like to have spreadsheets to better assist you.

Posting a spreadsheet along with your question helps us:

Understand your idea better
Help in preparing/fixing a formula to help meet your need
Explain why and what we did so that you and others may learn from this question.

To attach a file:

In your original post click on Edit Post.
At the bottom of the edit window you'll find the Go Advance button.
Click on the Paper Clip to add an attachment.
Click on Add File and select the spreadsheet you are having problems with.
Click Done

One last note, is protect your privacy and that of your company. Don't upload any spreadsheets with Personal or Company information/affiliations that would be detrimental in the hands of people who do not need to know.