Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2015, 07:11 AM
otuatail otuatail is offline Cell drop down boxes URGENT Windows 7 64bit Cell drop down boxes URGENT Office 2007
Competent Performer
Cell drop down boxes URGENT
 
Join Date: Jun 2012
Posts: 246
otuatail is on a distinguished road
Default Cell drop down boxes URGENT

Hi I have been given a work book and 1 sheet has drop down dates ranging from 13 aug 2012 to 12 May 2014 all Mondays. How can I change these. I have tried un hide sheet but there are no sheets hidden.
Reply With Quote
  #2  
Old 02-26-2015, 07:38 AM
otuatail otuatail is offline Cell drop down boxes URGENT Windows 7 64bit Cell drop down boxes URGENT Office 2007
Competent Performer
Cell drop down boxes URGENT
 
Join Date: Jun 2012
Posts: 246
otuatail is on a distinguished road
Default

If I select a cell >data tap > Data validation > data validation I get
=$R$2:$R$93
Reply With Quote
  #3  
Old 02-26-2015, 09:51 AM
gebobs gebobs is offline Cell drop down boxes URGENT Windows 7 64bit Cell drop down boxes URGENT Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Attach the sheet please.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell drop down boxes URGENT Using drop down boxes to access different data DSNake301 Word VBA 6 06-25-2014 01:18 AM
URGENT HELP NEEDED: Strange boxes over header area in Word 2010 zee_shah Word 1 10-31-2013 09:41 AM
excel drop down boxes kaschlegel Excel 1 07-22-2013 10:23 PM
Cell drop down boxes URGENT Dynamically creating new drop down boxes. dmncs Word VBA 1 05-06-2012 09:29 PM
Cell drop down boxes URGENT Drop Down Boxes Thomas Farmery Word 7 01-05-2011 01:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:19 AM.


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