| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell data validation
I'm working on a sheet that needs some validation. For example, in cell C4 they are supposed to enter their initials, but some enter their full name. I need to make sure that they enter ABC instead of Alex Billy Charlie. Then, they are supposed to enter the week ending date in cell K4. I'm wanting to add a calendar there, so they can the date. However, I only want my calendar to show week ending Saturdays. Then, when they enter the date, it will automatically fill in information in G10 (Sunday), G21 (Monday), G46 (Tuesday), G71 (Wednesday), etc... this will be the week of.. example: Enter date 06-18-05 in cell K4 G10 = 06-12-05 G21 = 06-13-05 G46 = 06-14-05 G71 = 06-15-05.... etc.... Sorry if the description is vague... Thanks, DejaVu -- DejaVu ------------------------------------------------------------------------ DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629 View this thread: http://www.excelforum.com/showthread...hreadid=380064 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell data validation
You have one response at your post in .misc.
DejaVu wrote: I'm working on a sheet that needs some validation. For example, in cell C4 they are supposed to enter their initials, but some enter their full name. I need to make sure that they enter ABC instead of Alex Billy Charlie. Then, they are supposed to enter the week ending date in cell K4. I'm wanting to add a calendar there, so they can the date. However, I only want my calendar to show week ending Saturdays. Then, when they enter the date, it will automatically fill in information in G10 (Sunday), G21 (Monday), G46 (Tuesday), G71 (Wednesday), etc... this will be the week of.. example: Enter date 06-18-05 in cell K4 G10 = 06-12-05 G21 = 06-13-05 G46 = 06-14-05 G71 = 06-15-05.... etc.... Sorry if the description is vague... Thanks, DejaVu -- DejaVu ------------------------------------------------------------------------ DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629 View this thread: http://www.excelforum.com/showthread...hreadid=380064 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| how blank data validation cell after changing dependent cell? | Excel Discussion (Misc queries) | |||
| Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
| Why does data validation not work when pasting data into a cell. | Excel Discussion (Misc queries) | |||
| data validation to restrict input in cell based on value of cell above that cell | Excel Programming | |||
![DejaVu[_19_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
