Link from 1 worksheet to 4 different worksheets
 

I'm trying to link one (1) Source data sheet row information based on Column
one (1) criteria to seperate worksheets identifed/labeled as Column one (1)
catagory. See below sample:

Source Data/Master worksheet

Item Date Ref # Issue Sent back
to

Product #1 Jan 10 Ser # 123 Bad Paint job ABC Paint
Product #3 Jan 9 Ser # 456 Metal is bent Metal Co
Product #2 Jan 12 Part #987 Wiring Malfuc Elect Co
Product #3 Jan 12 Part #998 Wiring shorted Elect Co

What I'm trying to do is have the Source Data worksheet/Master sheet
transfer/link the ROW data based on ITEM or COLUMN #1 to individual
worksheets Poduct #1, then another sheet Product #2 ...

This way I can enter data on one sheet but be able to track/review issues
product by individual product

Any ideas would be greatly welcomed!!

Thanks
John

Link from 1 worksheet to 4 different worksheets
 

You would probably be better off in the long run just by using one master
database, and then using the Data Filter AutoFilter feature to review
selections you wish to filter..........for instance, besides doing what you
want to do by product, you can see all the products you've had to send back
to Vendor#1, etc..........

Vaya con Dios,
Chuck, CABGx3



"john" wrote:

I'm trying to link one (1) Source data sheet row information based on Column
one (1) criteria to seperate worksheets identifed/labeled as Column one (1)
catagory. See below sample:

Source Data/Master worksheet

Item Date Ref # Issue Sent back
to

Product #1 Jan 10 Ser # 123 Bad Paint job ABC Paint
Product #3 Jan 9 Ser # 456 Metal is bent Metal Co
Product #2 Jan 12 Part #987 Wiring Malfuc Elect Co
Product #3 Jan 12 Part #998 Wiring shorted Elect Co

What I'm trying to do is have the Source Data worksheet/Master sheet
transfer/link the ROW data based on ITEM or COLUMN #1 to individual
worksheets Poduct #1, then another sheet Product #2 ...

This way I can enter data on one sheet but be able to track/review issues
product by individual product

Any ideas would be greatly welcomed!!

Thanks
John