| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel with a filter active an a certain value
Hi,
I have an excel sheet created with an autofilter. In a Word document i want to add a hyperlink to my excel but i only want to see specific information (so i would like to filter on a specific value of one of my columns). Example excel: column 1 column 2 A 1 A 2 B 3 C 1 A 3 When I open the excel (via Word with hyperlink) I only want to see the rows that contain value 'A' in column1. Is this possible? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open excel with a filter active an a certain value
I'd do this with an autoopen macro that filters the value on A.
"Elly Driesen-Schepens" wrote: Hi, I have an excel sheet created with an autofilter. In a Word document i want to add a hyperlink to my excel but i only want to see specific information (so i would like to filter on a specific value of one of my columns). Example excel: column 1 column 2 A 1 A 2 B 3 C 1 A 3 When I open the excel (via Word with hyperlink) I only want to see the rows that contain value 'A' in column1. Is this possible? Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Active cell as a reference to open a worksheet | Excel Worksheet Functions | |||
| Why would Show All not be active in Filter part of Data menu? | Excel Worksheet Functions | |||
| Active Cell in Auto Filter | Excel Discussion (Misc queries) | |||
| How do I get Excel to open with automatic calculations active? | Excel Discussion (Misc queries) | |||
| Filter range of only active cells??? | Excel Worksheet Functions | |||
Hybrid Mode
