Data Validation

[Pascale]

Basically there are three categories from which the user can selec
from.

Eg Issues Sub-issues Services-issues
- servicing - assessing - delay in assessing
- call centre - misquote
- information - website (no entry required)
- brochure


I would like the sub-issues and services-issues to depandant on th
issue first chosen, thus limiting the selection on the subissue an
servicing-issues drop down. Is this possible in Exce

 

[JulieD]

Hi Pascale

check out Debra Dalgleish's site especially - Data Validation dependant
lists ..

http://www.contextures.com/xlDataVal02.html

Cheers
JulieD

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/validation_and_indirect.zip
It's in the "Worksheet (No VBA)" section on page:
http://www.bygsoftware.com/examples/examples.htm

Shows how using "Data > Validation" and "INDIRECT()" you can populate a cell
from two dependant lists


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[Pascale]

Thanks heaps for the feedback, I have been able to use the indirec
function as suggested. Thanks again:

 

[kalpanaganeshm]

Informatics Outsourcing is an Offshore Data Management service company. Data Management Service includes all types of Data Conversion, File Conversion, XML Conversion, HTML Conversion,SGML Conversion, Document Conversion,DataEntry, Data Extraction and Validation,OCR and ICR Services with affordableprice. Our team to give the solution quickly and given requirements.