Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-21-2011, 10:36 AM
BullMouse BullMouse is offline Data validation using indirect function Windows 7 64bit Data validation using indirect function Office 2007
Novice
Data validation using indirect function
 
Join Date: Nov 2011
Posts: 2
BullMouse is on a distinguished road
Default Data validation using indirect function

I would like to include drop down lists on an Order Entry form. To do this I'm using DATA VALIDATION and the INDIRECT functions.



The application includes several Data Validation drop down lists. Two of these drop down lists are problematic, the rest work well.

The two problematic cells use the same SOURCE definition, a "product name", but each of the two cells is to present a different selection on the drop down list.

One of the drop down lists should present the "SIZE" of the selected product, the second drop down list should present the "WEIGHT". Both of these drop downs use the same SOURCE selection, i.e. "PRODUCT NAME".

Each Data Validation table is defined on its own worksheet using the same SOURCE reference and both using the INDIRECT function. I used the FORMULAS > CREATE FROM SELECTIONS command to define the table. The worksheet names, SIZE and WEIGHT, respectively.

When I defined the SIZE worksheet, the drop down list presented was correct and worked well.

I then defined the WEIGHT worksheet the same way and the drop down for the weights was correct and worked well.

The problem I have surfaced after defining the WEIGHT worksheet.

After defining the WEIGHT worksheet table and testing the SIZE worksheet validation again, the SIZE drop down list selection had been replaced by the WEIGHT drop down list selection.

The SOURCE entry is the only thing these two worksheets have in common.

Suggestions on how to resolve this problem?

thanks - BullMouse
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation with IF Klyxrastafari Excel 1 10-03-2011 04:41 PM
Data validation using indirect function Conditional data validation (list drop-down) click4akshay Excel 2 04-28-2011 01:51 PM
Outlook userform validation help aiwnjoo Outlook 0 12-08-2010 12:57 AM
Indirect zleyphox Excel 1 02-11-2010 09:57 AM
Trouble With Data Validation And Filtering On A Dropdown zura04 Excel 0 10-24-2006 12:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft