| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter list if hyperlink happen
Greeting,
I have a list of employees Names and IDs. All IDs are linked to another sheet that it has courses of employees. I am using the following formula and it works grate. What is happen if linked happen , it takes me to the first cell of employee ID that is matched and other IDs also shown. What I want to do if link happened, only the employee ID shown in Sheet of Course only, other IDs of employees to be hidden. How to do that? This is the formula that I am using: =HYPERLINK("#"&CELL("address",INDIRECT("'"& E4 &"'!c4")),D4) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to filter list if hyperlink happen
Combine AutoFiltering with your table. Once you have jumped using the
hyperlink, use AutoFilter to hide the unwanted rows. -- Gary''s Student - gsnu200820 "Jon" wrote: Greeting, I have a list of employees Names and IDs. All IDs are linked to another sheet that it has courses of employees. I am using the following formula and it works grate. What is happen if linked happen , it takes me to the first cell of employee ID that is matched and other IDs also shown. What I want to do if link happened, only the employee ID shown in Sheet of Course only, other IDs of employees to be hidden. How to do that? This is the formula that I am using: =HYPERLINK("#"&CELL("address",INDIRECT("'"& E4 &"'!c4")),D4) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to filter list if hyperlink happen
Thank you Gary, would you please explain more?
"Gary''s Student" wrote: Combine AutoFiltering with your table. Once you have jumped using the hyperlink, use AutoFilter to hide the unwanted rows. -- Gary''s Student - gsnu200820 "Jon" wrote: Greeting, I have a list of employees Names and IDs. All IDs are linked to another sheet that it has courses of employees. I am using the following formula and it works grate. What is happen if linked happen , it takes me to the first cell of employee ID that is matched and other IDs also shown. What I want to do if link happened, only the employee ID shown in Sheet of Course only, other IDs of employees to be hidden. How to do that? This is the formula that I am using: =HYPERLINK("#"&CELL("address",INDIRECT("'"& E4 &"'!c4")),D4) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to filter list if hyperlink happen
Sure, say we hyperlinked to John Cabral's first record:
ID31416 Cabral, John <lots more data We then click on the top of the ID column and select ID31416. Then only Cabral's records would be visible. -- Gary''s Student - gsnu200820 "Jon" wrote: Thank you Gary, would you please explain more? "Gary''s Student" wrote: Combine AutoFiltering with your table. Once you have jumped using the hyperlink, use AutoFilter to hide the unwanted rows. -- Gary''s Student - gsnu200820 "Jon" wrote: Greeting, I have a list of employees Names and IDs. All IDs are linked to another sheet that it has courses of employees. I am using the following formula and it works grate. What is happen if linked happen , it takes me to the first cell of employee ID that is matched and other IDs also shown. What I want to do if link happened, only the employee ID shown in Sheet of Course only, other IDs of employees to be hidden. How to do that? This is the formula that I am using: =HYPERLINK("#"&CELL("address",INDIRECT("'"& E4 &"'!c4")),D4) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to filter list if hyperlink happen
Thank you Gary, what I meant is how to make autofilter
"Gary''s Student" wrote: Sure, say we hyperlinked to John Cabral's first record: ID31416 Cabral, John <lots more data We then click on the top of the ID column and select ID31416. Then only Cabral's records would be visible. -- Gary''s Student - gsnu200820 "Jon" wrote: Thank you Gary, would you please explain more? "Gary''s Student" wrote: Combine AutoFiltering with your table. Once you have jumped using the hyperlink, use AutoFilter to hide the unwanted rows. -- Gary''s Student - gsnu200820 "Jon" wrote: Greeting, I have a list of employees Names and IDs. All IDs are linked to another sheet that it has courses of employees. I am using the following formula and it works grate. What is happen if linked happen , it takes me to the first cell of employee ID that is matched and other IDs also shown. What I want to do if link happened, only the employee ID shown in Sheet of Course only, other IDs of employees to be hidden. How to do that? This is the formula that I am using: =HYPERLINK("#"&CELL("address",INDIRECT("'"& E4 &"'!c4")),D4) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to filter list if hyperlink happen
Before you do any hyperlink, click on the table column header cell ( say A1)
and pull-down: Data Filter Autofilter -- Gary''s Student - gsnu200820 "Jon" wrote: Thank you Gary, what I meant is how to make autofilter "Gary''s Student" wrote: Sure, say we hyperlinked to John Cabral's first record: ID31416 Cabral, John <lots more data We then click on the top of the ID column and select ID31416. Then only Cabral's records would be visible. -- Gary''s Student - gsnu200820 "Jon" wrote: Thank you Gary, would you please explain more? "Gary''s Student" wrote: Combine AutoFiltering with your table. Once you have jumped using the hyperlink, use AutoFilter to hide the unwanted rows. -- Gary''s Student - gsnu200820 "Jon" wrote: Greeting, I have a list of employees Names and IDs. All IDs are linked to another sheet that it has courses of employees. I am using the following formula and it works grate. What is happen if linked happen , it takes me to the first cell of employee ID that is matched and other IDs also shown. What I want to do if link happened, only the employee ID shown in Sheet of Course only, other IDs of employees to be hidden. How to do that? This is the formula that I am using: =HYPERLINK("#"&CELL("address",INDIRECT("'"& E4 &"'!c4")),D4) |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to filter list if hyperlink happen
hi Gary, there is no autofilter Option, I am using 2007
"Gary''s Student" wrote: Before you do any hyperlink, click on the table column header cell ( say A1) and pull-down: Data Filter Autofilter -- Gary''s Student - gsnu200820 "Jon" wrote: Thank you Gary, what I meant is how to make autofilter "Gary''s Student" wrote: Sure, say we hyperlinked to John Cabral's first record: ID31416 Cabral, John <lots more data We then click on the top of the ID column and select ID31416. Then only Cabral's records would be visible. -- Gary''s Student - gsnu200820 "Jon" wrote: Thank you Gary, would you please explain more? "Gary''s Student" wrote: Combine AutoFiltering with your table. Once you have jumped using the hyperlink, use AutoFilter to hide the unwanted rows. -- Gary''s Student - gsnu200820 "Jon" wrote: Greeting, I have a list of employees Names and IDs. All IDs are linked to another sheet that it has courses of employees. I am using the following formula and it works grate. What is happen if linked happen , it takes me to the first cell of employee ID that is matched and other IDs also shown. What I want to do if link happened, only the employee ID shown in Sheet of Course only, other IDs of employees to be hidden. How to do that? This is the formula that I am using: =HYPERLINK("#"&CELL("address",INDIRECT("'"& E4 &"'!c4")),D4) |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to filter list if hyperlink happen
Click the Data Tab, Don't you then see the FILTER (Icon and Text)?
"Jon" wrote: hi Gary, there is no autofilter Option, I am using 2007 "Gary''s Student" wrote: Before you do any hyperlink, click on the table column header cell ( say A1) and pull-down: Data Filter Autofilter -- Gary''s Student - gsnu200820 "Jon" wrote: Thank you Gary, what I meant is how to make autofilter "Gary''s Student" wrote: Sure, say we hyperlinked to John Cabral's first record: ID31416 Cabral, John <lots more data We then click on the top of the ID column and select ID31416. Then only Cabral's records would be visible. -- Gary''s Student - gsnu200820 "Jon" wrote: Thank you Gary, would you please explain more? "Gary''s Student" wrote: Combine AutoFiltering with your table. Once you have jumped using the hyperlink, use AutoFilter to hide the unwanted rows. -- Gary''s Student - gsnu200820 "Jon" wrote: Greeting, I have a list of employees Names and IDs. All IDs are linked to another sheet that it has courses of employees. I am using the following formula and it works grate. What is happen if linked happen , it takes me to the first cell of employee ID that is matched and other IDs also shown. What I want to do if link happened, only the employee ID shown in Sheet of Course only, other IDs of employees to be hidden. How to do that? This is the formula that I am using: =HYPERLINK("#"&CELL("address",INDIRECT("'"& E4 &"'!c4")),D4) |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to filter list if hyperlink happen
yes , I see it!!! I click on it after that the header is filter and i but the
hyper link but does not work?? "JMay" wrote: Click the Data Tab, Don't you then see the FILTER (Icon and Text)? "Jon" wrote: hi Gary, there is no autofilter Option, I am using 2007 "Gary''s Student" wrote: Before you do any hyperlink, click on the table column header cell ( say A1) and pull-down: Data Filter Autofilter -- Gary''s Student - gsnu200820 "Jon" wrote: Thank you Gary, what I meant is how to make autofilter "Gary''s Student" wrote: Sure, say we hyperlinked to John Cabral's first record: ID31416 Cabral, John <lots more data We then click on the top of the ID column and select ID31416. Then only Cabral's records would be visible. -- Gary''s Student - gsnu200820 "Jon" wrote: Thank you Gary, would you please explain more? "Gary''s Student" wrote: Combine AutoFiltering with your table. Once you have jumped using the hyperlink, use AutoFilter to hide the unwanted rows. -- Gary''s Student - gsnu200820 "Jon" wrote: Greeting, I have a list of employees Names and IDs. All IDs are linked to another sheet that it has courses of employees. I am using the following formula and it works grate. What is happen if linked happen , it takes me to the first cell of employee ID that is matched and other IDs also shown. What I want to do if link happened, only the employee ID shown in Sheet of Course only, other IDs of employees to be hidden. How to do that? This is the formula that I am using: =HYPERLINK("#"&CELL("address",INDIRECT("'"& E4 &"'!c4")),D4) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| Wow... Anyone ever seen this happen? | Excel Discussion (Misc queries) | |||
| Why is that happen ? | Excel Worksheet Functions | |||
| why would this happen? | Excel Discussion (Misc queries) | |||
| How does this happen...filename.xls:1 ...xls:2 | Excel Discussion (Misc queries) | |||
Linear Mode
