J
john
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
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