I am trying to figure out how to link a cell to a list on another
worksheet. What I would like to do is have a function that searches an
array of cells against a fixed cell and return a link to a list on
another page that matches the fixed cell. For example, this is what I
would like to do.
On Sheet1 all of the columns are shown as lists.
Sheet1....|....Col A..........|....Col B....|.....Col C....|
Row 1.....|....PO#............|....Item#..|......QTY.. ..|
Row 2.....|....LL-16-1.......|........1......|......10.......|
Row 3.....|....LL-16-1.......|........2......|......15.......|
Row 4.....|....LL-16-1.......|........3......|......20.......|
Row 5.....|....LL-16-2.......|........1......|......11.......|
Row 6.....|....LL-16-2.......|........2......|......21.......|
Sheet2...|....Col A.............|.....Col B..........|....Col
C....|....Col D...|
Row 1.....|....Link
Function..|.....PO#...........|....Item#...|.....Q TY...|
Row 2.....|....A2
Function....|.....LL-16-1......|.......1........|......10.....|
Row 3.....|....A3
Function....|.....LL-16-1......|.......2........|......15.....|
Row 4.....|....A4
Function....|.....LL-16-1......|.......3........|......20.....|
Row 5.....|....A5
Function....|.....LL-16-2......|.......1........|......11.....|
Row 6.....|....A6
Function....|.....LL-16-2......|.......2........|......21.....|
For example I would like the A2 function to work like this. If
Sheet2!B2 = Sheet1!A2:A6 then provide a link in Sheet2!A2 that directs
you to Sheet1 and only displays the rows where the PO#’s in Sheet1
A2:A6 match B2 on Sheet2 which in this case would link to rows 2, 3, &
4 on Sheet1. Like I said this is only an example and in reality I have
about 2000 rows with entries. I do not know if there is even a way to
do this but if anyone has any suggestions I would really appreciate it.
Thanks.
--
jdurrmsu
------------------------------------------------------------------------
jdurrmsu's Profile:
http://www.excelforum.com/member.php...o&userid=27122
View this thread:
http://www.excelforum.com/showthread...hreadid=508172