Automatic, Dependent Cell Values

		Microsoft Office Forums > Microsoft Excel > Excel
Automatic, Dependent Cell Values

08-26-2011, 07:01 AM

flackend

Windows XP Automatic, Dependent Cell Values

Office 2003

Novice

Join Date: Aug 2011

Posts: 6

I created another column, column C, with the start time + two hours formula:

Code:

=IF(A1 <> "", A1 + TIME(2,0,0), "")

Then I hid the column. Then set the data validation (list) for the end time column (column B) to this formula:

Code:

=OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,1,1,1)

Which gives a drop-down list that contains only the contents of the cell one column to the right (which contains the start time + two hours).

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dependent drop down lists in Word 2007	benbenasc	Word VBA	0	08-24-2011 06:34 AM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM
How to create a Dependent Drop-Down Picklist	ComcoDG	Word	2	03-17-2009 07:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 AM.