Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link to worksheet from several other worksheets in different workb | Excel Discussion (Misc queries) | |||
Link Worksheet to other worksheets | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions | |||
how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions |