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