Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Conditional data validation (list drop-down) Conditional data validation (list drop-down)
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 04-28-2011, 06:04 AM
macropod's Avatar
macropod macropod is offline Conditional data validation (list drop-down) Windows 7 32bit Conditional data validation (list drop-down) Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,514
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi AK,

See the attached demonstration of the concept.
Attached Files
File Type: zip Dependent Dropdowns.zip (66.1 KB, 135 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 04-28-2011, 01:51 PM
click4akshay click4akshay is offline Conditional data validation (list drop-down) Windows XP Conditional data validation (list drop-down) Office 2007
Novice
Conditional data validation (list drop-down) 		 
Join Date: Apr 2011
Posts: 2
click4akshay is on a distinguished road
Default Thanks a ton
Quote:
Originally Posted by macropod View Post
Hi AK,

See the attached demonstration of the concept.
Hi Macropod,

Thanks a lot for the solution.
Very interesting use of 'OFFSET' function.
Learnt a great deal.

Kudos,
AK
Reply With Quote
Reply

Tags
drop-down, excel 2007, list

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Drop Down List Box hbradshaw Word VBA 0 09-27-2010 06:24 AM
Drop Down List and Functions (Linking) sten Excel 0 03-17-2010 03:03 PM
Long List for drop down box DLo99 Word 0 02-28-2010 08:07 AM
Conditional data validation (list drop-down) Conditional Expression that Moves Data (challenging) themangoagent Excel 1 02-20-2010 11:29 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 03:46 AM.

Contact Us - Privacy Statement - Top

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