View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Elly Driesen-Schepens Elly Driesen-Schepens is offline
external usenet poster
 
Posts: 1
Default 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!