Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Locking Data in a specific cell depending on selection of another

Hello,

I have chart with headings as follows:
Name Skill Status In Train Date Qual Date Cert Date

What I have been asked to to is as follows:
I created a list for the status. 3 options In Train, Qual, Cert. When the
training focal point selects In Train I need the current date to be entered
into In Train Date column. Then when the focal point changes Status column to
Qual, I need the in Train Date column to remain as original date, and then
the current date to be put in the Qual Date column, and same for Cert Date.
Also if the status is change to a blank(operator left) want to clear the
dates.

Hope thats not too confusing to understand.
Thanks in advance for your assistance

CrimsonPlague29

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Jump to a different cell depending on list selection Karen Sigel New Users to Excel 3 November 3rd 09 02:32 PM
Locking cell depending on outcome of formulae Janelle S[_2_] Excel Discussion (Misc queries) 0 March 26th 08 07:55 AM
VLOOKUP or dropdown in the cell depending on selection in another Spottydog Excel Discussion (Misc queries) 1 January 31st 07 07:59 AM
Dynamically locking a cell depending upon value of another cell. Pank Excel Discussion (Misc queries) 0 May 12th 06 11:48 AM
Lock data in a cell a specific cell based on selection on other ce CrimsonPlague29 Excel Worksheet Functions 0 May 10th 06 11:06 AM


All times are GMT +1. The time now is 06:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"