A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data validation dependant drop down on unsorted list



 
 
Thread Tools Display Modes
  #1  
Old December 3rd, 2009, 05:34 AM posted to microsoft.public.excel.worksheet.functions
Reacher21
external usenet poster
 
Posts: 3
Default Data validation dependant drop down on unsorted list

I can't see a solution on contextures.com or here so hoping someone can put
me out of my misery!
I have a master list of vessel names on Sheet1 Column A. On Sheet2 is my
data repository where I record all voyages of vessels I'm tracking and some
vessels make multiple voyages differentiated by a different departure date.
The vessel name for each voyage is chosen by validated drop down based on
list in sheet1. Next to that is the departure date and other details related
to cargo etc.
On Sheet3 I wish to use a template invoice which has a drop down for vessel
name, and then a drop down to choose from the departure dates related to the
chosen vessel. The data on Sheet2 is sorted by departure date and I would
like to keep it that way for other reasons. I set up contextures' solution
for sorted list only to realise that it must be sorted by the vessel name. I
don't want to use pivots or macros if I can help it. Thanks for any help.
  #2  
Old December 3rd, 2009, 05:46 AM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default Data validation dependant drop down on unsorted list

Considering all the things you don't want to do, then this becomes "work
intensive".

What you'd have to do is make a separate list for each unique vessel with
its departure dates then use that data as the source for your drop down.

--
Biff
Microsoft Excel MVP


"Reacher21" wrote in message
news
I can't see a solution on contextures.com or here so hoping someone can put
me out of my misery!
I have a master list of vessel names on Sheet1 Column A. On Sheet2 is my
data repository where I record all voyages of vessels I'm tracking and
some
vessels make multiple voyages differentiated by a different departure
date.
The vessel name for each voyage is chosen by validated drop down based on
list in sheet1. Next to that is the departure date and other details
related
to cargo etc.
On Sheet3 I wish to use a template invoice which has a drop down for
vessel
name, and then a drop down to choose from the departure dates related to
the
chosen vessel. The data on Sheet2 is sorted by departure date and I would
like to keep it that way for other reasons. I set up contextures' solution
for sorted list only to realise that it must be sorted by the vessel name.
I
don't want to use pivots or macros if I can help it. Thanks for any help.



  #3  
Old December 3rd, 2009, 07:05 AM posted to microsoft.public.excel.worksheet.functions
Reacher21
external usenet poster
 
Posts: 3
Default Data validation dependant drop down on unsorted list

Hi Biff, Thanks for your response. I guess if there is a way of using pivots
and/or VBA that doesn't require the end-user of this file to be literate in
using either pivots or VBA then I'm all ears. I need it to be automated which
is why I was looking at the formula route. Any suggestions?

"T. Valko" wrote:

Considering all the things you don't want to do, then this becomes "work
intensive".

What you'd have to do is make a separate list for each unique vessel with
its departure dates then use that data as the source for your drop down.

--
Biff
Microsoft Excel MVP


"Reacher21" wrote in message
news
I can't see a solution on contextures.com or here so hoping someone can put
me out of my misery!
I have a master list of vessel names on Sheet1 Column A. On Sheet2 is my
data repository where I record all voyages of vessels I'm tracking and
some
vessels make multiple voyages differentiated by a different departure
date.
The vessel name for each voyage is chosen by validated drop down based on
list in sheet1. Next to that is the departure date and other details
related
to cargo etc.
On Sheet3 I wish to use a template invoice which has a drop down for
vessel
name, and then a drop down to choose from the departure dates related to
the
chosen vessel. The data on Sheet2 is sorted by departure date and I would
like to keep it that way for other reasons. I set up contextures' solution
for sorted list only to realise that it must be sorted by the vessel name.
I
don't want to use pivots or macros if I can help it. Thanks for any help.



.

  #4  
Old December 3rd, 2009, 07:41 AM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default Data validation dependant drop down on unsorted list

Here's a small sample file that uses formulas to do this.

xReacher21.xls 20 kb

http://cjoint.com/?mdhLqagJJc

If you think you can use this and you have any questions just ask.

--
Biff
Microsoft Excel MVP


"Reacher21" wrote in message
...
Hi Biff, Thanks for your response. I guess if there is a way of using
pivots
and/or VBA that doesn't require the end-user of this file to be literate
in
using either pivots or VBA then I'm all ears. I need it to be automated
which
is why I was looking at the formula route. Any suggestions?

"T. Valko" wrote:

Considering all the things you don't want to do, then this becomes "work
intensive".

What you'd have to do is make a separate list for each unique vessel with
its departure dates then use that data as the source for your drop down.

--
Biff
Microsoft Excel MVP


"Reacher21" wrote in message
news
I can't see a solution on contextures.com or here so hoping someone can
put
me out of my misery!
I have a master list of vessel names on Sheet1 Column A. On Sheet2 is
my
data repository where I record all voyages of vessels I'm tracking and
some
vessels make multiple voyages differentiated by a different departure
date.
The vessel name for each voyage is chosen by validated drop down based
on
list in sheet1. Next to that is the departure date and other details
related
to cargo etc.
On Sheet3 I wish to use a template invoice which has a drop down for
vessel
name, and then a drop down to choose from the departure dates related
to
the
chosen vessel. The data on Sheet2 is sorted by departure date and I
would
like to keep it that way for other reasons. I set up contextures'
solution
for sorted list only to realise that it must be sorted by the vessel
name.
I
don't want to use pivots or macros if I can help it. Thanks for any
help.



.



  #5  
Old December 3rd, 2009, 10:50 AM posted to microsoft.public.excel.worksheet.functions
Reacher21
external usenet poster
 
Posts: 3
Default Data validation dependant drop down on unsorted list

Thank you very much Biff. The list of dates per vessel was preferable to
running VB and I built in allowance for new vessels etc. Thanks again.

"T. Valko" wrote:

Here's a small sample file that uses formulas to do this.

xReacher21.xls 20 kb

http://cjoint.com/?mdhLqagJJc

If you think you can use this and you have any questions just ask.

--
Biff
Microsoft Excel MVP


"Reacher21" wrote in message
...
Hi Biff, Thanks for your response. I guess if there is a way of using
pivots
and/or VBA that doesn't require the end-user of this file to be literate
in
using either pivots or VBA then I'm all ears. I need it to be automated
which
is why I was looking at the formula route. Any suggestions?

"T. Valko" wrote:

Considering all the things you don't want to do, then this becomes "work
intensive".

What you'd have to do is make a separate list for each unique vessel with
its departure dates then use that data as the source for your drop down.

--
Biff
Microsoft Excel MVP


"Reacher21" wrote in message
news I can't see a solution on contextures.com or here so hoping someone can
put
me out of my misery!
I have a master list of vessel names on Sheet1 Column A. On Sheet2 is
my
data repository where I record all voyages of vessels I'm tracking and
some
vessels make multiple voyages differentiated by a different departure
date.
The vessel name for each voyage is chosen by validated drop down based
on
list in sheet1. Next to that is the departure date and other details
related
to cargo etc.
On Sheet3 I wish to use a template invoice which has a drop down for
vessel
name, and then a drop down to choose from the departure dates related
to
the
chosen vessel. The data on Sheet2 is sorted by departure date and I
would
like to keep it that way for other reasons. I set up contextures'
solution
for sorted list only to realise that it must be sorted by the vessel
name.
I
don't want to use pivots or macros if I can help it. Thanks for any
help.


.



.

  #6  
Old December 3rd, 2009, 06:11 PM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default Data validation dependant drop down on unsorted list

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Reacher21" wrote in message
...
Thank you very much Biff. The list of dates per vessel was preferable to
running VB and I built in allowance for new vessels etc. Thanks again.

"T. Valko" wrote:

Here's a small sample file that uses formulas to do this.

xReacher21.xls 20 kb

http://cjoint.com/?mdhLqagJJc

If you think you can use this and you have any questions just ask.

--
Biff
Microsoft Excel MVP


"Reacher21" wrote in message
...
Hi Biff, Thanks for your response. I guess if there is a way of using
pivots
and/or VBA that doesn't require the end-user of this file to be
literate
in
using either pivots or VBA then I'm all ears. I need it to be automated
which
is why I was looking at the formula route. Any suggestions?

"T. Valko" wrote:

Considering all the things you don't want to do, then this becomes
"work
intensive".

What you'd have to do is make a separate list for each unique vessel
with
its departure dates then use that data as the source for your drop
down.

--
Biff
Microsoft Excel MVP


"Reacher21" wrote in message
news I can't see a solution on contextures.com or here so hoping someone
can
put
me out of my misery!
I have a master list of vessel names on Sheet1 Column A. On Sheet2
is
my
data repository where I record all voyages of vessels I'm tracking
and
some
vessels make multiple voyages differentiated by a different
departure
date.
The vessel name for each voyage is chosen by validated drop down
based
on
list in sheet1. Next to that is the departure date and other details
related
to cargo etc.
On Sheet3 I wish to use a template invoice which has a drop down for
vessel
name, and then a drop down to choose from the departure dates
related
to
the
chosen vessel. The data on Sheet2 is sorted by departure date and I
would
like to keep it that way for other reasons. I set up contextures'
solution
for sorted list only to realise that it must be sorted by the vessel
name.
I
don't want to use pivots or macros if I can help it. Thanks for any
help.


.



.



  #7  
Old April 23rd, 2010, 04:32 PM posted to microsoft.public.excel.worksheet.functions
Roger D[_3_]
external usenet poster
 
Posts: 1
Default Looking for the sample file

I am looking to check out xReacher21.xls to see if it will do what I am looking for. Unfortunately, the link is dead. Any chance of posting a new link for the file?



T. Valko wrote:

Here is a small sample file that uses formulas to do this.xReacher21.
03-Dec-09

Here is a small sample file that uses formulas to do this.

xReacher21.xls 20 kb

http://cjoint.com/?mdhLqagJJc

If you think you can use this and you have any questions just ask.

--
Biff
Microsoft Excel MVP

Previous Posts In This Thread:

On Wednesday, December 02, 2009 11:34 PM
Reacher21 wrote:

Data validation dependant drop down on unsorted list
I cannot see a solution on contextures.com or here so hoping someone can put
me out of my misery!
I have a master list of vessel names on Sheet1 Column A. On Sheet2 is my
data repository where I record all voyages of vessels I am tracking and some
vessels make multiple voyages differentiated by a different departure date.
The vessel name for each voyage is chosen by validated drop down based on
list in sheet1. Next to that is the departure date and other details related
to cargo etc.
On Sheet3 I wish to use a template invoice which has a drop down for vessel
name, and then a drop down to choose from the departure dates related to the
chosen vessel. The data on Sheet2 is sorted by departure date and I would
like to keep it that way for other reasons. I set up contextures' solution
for sorted list only to realise that it must be sorted by the vessel name. I
do not want to use pivots or macros if I can help it. Thanks for any help.

On Wednesday, December 02, 2009 11:46 PM
T. Valko wrote:

Considering all the things you do not want to do, then this becomes
Considering all the things you do not want to do, then this becomes "work
intensive".

What you would have to do is make a separate list for each unique vessel with
its departure dates then use that data as the source for your drop down.

--
Biff
Microsoft Excel MVP

On Thursday, December 03, 2009 1:05 AM
Reacher21 wrote:

Hi Biff, Thanks for your response.
Hi Biff, Thanks for your response. I guess if there is a way of using pivots
and/or VBA that does not require the end-user of this file to be literate in
using either pivots or VBA then I am all ears. I need it to be automated which
is why I was looking at the formula route. Any suggestions?

"T. Valko" wrote:

On Thursday, December 03, 2009 1:41 AM
T. Valko wrote:

Here is a small sample file that uses formulas to do this.xReacher21.
Here is a small sample file that uses formulas to do this.

xReacher21.xls 20 kb

http://cjoint.com/?mdhLqagJJc

If you think you can use this and you have any questions just ask.

--
Biff
Microsoft Excel MVP

On Thursday, December 03, 2009 4:50 AM
Reacher21 wrote:

Thank you very much Biff.
Thank you very much Biff. The list of dates per vessel was preferable to
running VB and I built in allowance for new vessels etc. Thanks again.

"T. Valko" wrote:

On Thursday, December 03, 2009 12:11 PM
T. Valko wrote:

You're welcome. Thanks for the feedback!--BiffMicrosoft Excel MVP
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


Submitted via EggHeadCafe - Software Developer Portal of Choice
A Framework to Animate WPF and Silverlight Pages Similar to the PowerPoint Slides
http://www.eggheadcafe.com/tutorials...nimate-wp.aspx
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:26 AM.


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