Hey guys,
I just can't seem to figure this out without using macros, but I am not allowed to use it at work. Basically what I need to figure out is
Workbook with 3 sheets - Sheet1 (Links), Sheet2 (Database) , Sheet3 (Output)
Sheet1 has item groups, i.e Cell A1(Shirts), A2(Pants), A3(Socks) etc..
Sheet2 has the database A1(Group), B1(Size), C1(Color)
A2 Shirts ...........................
A3 Shirts............................
A4 Pants............................
A5 Pants............................
Sheet3 I need to have it display all rows that have for example "Pants" in Column A when I click the link in Sheet1, A2 (Pants)
I can't wrap my head around doing this without VBA...
Does anybody have an idea and can lead me to the right direction?
Thanks in advance,
Dan
I just can't seem to figure this out without using macros, but I am not allowed to use it at work. Basically what I need to figure out is
Workbook with 3 sheets - Sheet1 (Links), Sheet2 (Database) , Sheet3 (Output)
Sheet1 has item groups, i.e Cell A1(Shirts), A2(Pants), A3(Socks) etc..
Sheet2 has the database A1(Group), B1(Size), C1(Color)
A2 Shirts ...........................
A3 Shirts............................
A4 Pants............................
A5 Pants............................
Sheet3 I need to have it display all rows that have for example "Pants" in Column A when I click the link in Sheet1, A2 (Pants)
I can't wrap my head around doing this without VBA...
Does anybody have an idea and can lead me to the right direction?
Thanks in advance,
Dan