LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Filter Static List

Hello Everybody

I have a (3 column) static list in Sheet 2 and need to filter that list by a
selected cell on sheet 1. I would like to set it up so that when I type a
list name in the selected cell in sheet 1 that it filters the list in sheet 2
in place. I do not want to copy the data into another sheet, I want to
filter the actual list. Sorry If I sound a lttle vague, I am new to this.

thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula (not adv. filter) to list unique values from list Brian Excel Worksheet Functions 3 May 12th 09 04:33 AM
List Creation from Static tab gary Excel Worksheet Functions 5 January 3rd 08 06:43 AM
filter: how to print filter list options in dropdown box help please Excel Discussion (Misc queries) 2 October 17th 07 01:53 AM
Filter the results of a list based on a previous vlookup against the same list Mizpah Excel Worksheet Functions 2 August 18th 06 10:28 AM
Lookup from Static List/Array Support Excel Worksheet Functions 2 February 17th 06 06:40 PM


All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"