| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a "To Do" List
My objective is to create a list of actions to be taken today. On one worksheet I have dates in Column A which are in order 1/1/05, 1/2/05, 1/3/05, etc. In column B there is a different activity for each day. Obviously it is easy to use VLOOKUP Today() to capture todays activity and print it in a column 1 on a report. In Column C the dates are in random order and many cells are blank. Whenever there is a date in Column C there is an accompanying activity in Column D. How can I capture todays activity and print it in column 2 of the report? What happens if todays date appears twice in Column C? Thank you in advance for any ideas you can offer. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
| Creating an "If" Function with multiple "if"s | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
Threaded Mode
