Prev Previous Post   Next Post Next
  #1   Report Post  
Jaytee
 
Posts: n/a
Default Lists

Okay, Sheet 1 ("Entry") Looks like this:

A B C D
1 Property Date Not Working Features I Like
2 Prop 1 8/14/05 Blender View
3 Prop 2 8/19/05 Bedrooms
4 Prop 1 5/19/05 Blender Landscaping
5 Prop 3 7/11/05 Deadbolt
6 Prop 2 9/15/05 MainTV View
7 Prop 1 10/12/05 Icemaker View

Sheet 2 ("Owners") Must function like this:
(A2 is a drop down list containing the names of properties from sheet 1.
Step 1 in this process is to select a property from this list, hence "Prop 1"
in A2)
A B C D
1 Property Not Working Features I Like
2 Prop 1 Blender View
3 Blender Landscaping
4 Icemaker View
5

So the Question is:
When I select "Prop 1" from My drop list in A2 on the "Owners" sheet, how do
I get the list of information only pertinant to Prop 1 In columns B and C?
Obviously I want to select Prop 2 and get Prop 2 Info if I so choose.
Any Help would be appreciated!

Jaytee

 
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
Formatting lists question coal_miner Excel Discussion (Misc queries) 0 June 3rd 05 06:00 PM
How do I return dynamic lists? liciakay Excel Worksheet Functions 1 March 30th 05 08:22 AM
Comparing 2 Customer Lists to Identify Shared Customers carl Excel Worksheet Functions 2 January 26th 05 07:17 PM
Aligning Two Lists in Excel Rich Excel Discussion (Misc queries) 2 December 4th 04 05:44 PM
finding common numbers in large lists Jenn Excel Worksheet Functions 1 November 11th 04 07:42 PM


All times are GMT +1. The time now is 08:20 PM.

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"