coolguykets1
Board Regular
- Joined
- Feb 6, 2013
- Messages
- 94
I have specific numeric values in column J. From Row 11. in one sheet.
The linked data is in another tab called "Equip ID" in the same file. I want to click that particular value in Column J cells in one sheet and once i click it it should take me to tab "Equip ID" search it in column A of that another tab and give me rows only with that value in column A.
i.e Autofilter "Headers in Equip ID" sheet Row1
The headers in the another sheet"Equip ID" are as below from A1 to E1.
[TABLE="width: 980"]
<tbody>[TR]
[TD="class: xl64, width: 196"][/TD]
[TD="class: xl64, width: 196"][/TD]
[TD="class: xl64, width: 196"][/TD]
[TD="class: xl64, width: 196"][/TD]
[TD="class: xl64, width: 196"][/TD]
[/TR]
</tbody>[/TABLE]
The linked data is in another tab called "Equip ID" in the same file. I want to click that particular value in Column J cells in one sheet and once i click it it should take me to tab "Equip ID" search it in column A of that another tab and give me rows only with that value in column A.
i.e Autofilter "Headers in Equip ID" sheet Row1
The headers in the another sheet"Equip ID" are as below from A1 to E1.
[TABLE="width: 980"]
<tbody>[TR]
[TD="class: xl64, width: 196"][/TD]
[TD="class: xl64, width: 196"][/TD]
[TD="class: xl64, width: 196"][/TD]
[TD="class: xl64, width: 196"][/TD]
[TD="class: xl64, width: 196"][/TD]
[/TR]
</tbody>[/TABLE]
Last edited: