RE: $$Excel-Macros$$ Using an "if" formula in data validation

2010-05-01 Thread Dave Bonallack
You're welcome. I have found the Contextures site very helpful for lots of tasks. Regards - Dave. Date: Sat, 1 May 2010 06:11:26 -0500 Subject: Re: $$Excel-Macros$$ Using an "if" formula in data validation From: tanner@gmail.com To: excel-macros@googlegroups.com Dave,

Re: $$Excel-Macros$$ Using an "if" formula in data validation

2010-05-01 Thread LJ Tanner
Dave, thank you very much. Great instructions at contextures. On Fri, Apr 30, 2010 at 4:53 PM, LJWarren wrote: > I have 5 major categories defined, and depending on which category is > chosen, up to 20 sub-categories. How do I embed an "if" statement into > my data validation? Thank you. > > --

RE: $$Excel-Macros$$ Using an "if" formula in data validation

2010-05-01 Thread Dave Bonallack
Hi, Try this address: http://www.contextures.com/tiptech.html Then go to Data Validation, dependent drop-downs. There are several methods. Regards - Dave _ If It Exists, You'll Find it on

Re: $$Excel-Macros$$ Using an "if" formula in data validation

2010-05-01 Thread Deepak Rai
Hi, Plz share a sample file. Regards, Deepak On Sat, May 1, 2010 at 3:23 AM, LJWarren wrote: > I have 5 major categories defined, and depending on which category is > chosen, up to 20 sub-categories. How do I embed an "if" statement into > my data validation? Thank you. > > -- > > ---

$$Excel-Macros$$ Using an "if" formula in data validation

2010-04-30 Thread LJWarren
I have 5 major categories defined, and depending on which category is chosen, up to 20 sub-categories. How do I embed an "if" statement into my data validation? Thank you. -- -- Some important links for excel users: 1