Thread: [Solved] Automatically select first item in drop-down?
View Single Post
 
Old 08-28-2011, 05:48 AM
nutrastat nutrastat is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
  
Join Date: Aug 2011
Location: Brighton, UK
Posts: 36
nutrastat is on a distinguished road
Default Why Two Validation Lists?
Hi,

Note sure why you have two validation lists, when the second is always 2 hours different.

See attached example, I have created a short time validation list to the right. Select time in Col A, and Col C will show new time, plus 2 hours.

Hope this helps.
Attached Files
File Type: xlsx Time Example Doc.xlsx (10.6 KB, 50 views)
Reply With Quote