Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
import access dates into xl calendar
Hello, hopefully you can help me out with a concept I'm struggling with, I've got a Tasks table in Access with 3 fields: task names, start dates, and due dates. I'd like to export this data into Excel so that the excel columns are days of the month (1-31 columns). The rows would contain the Tasks data, such that a task whose start date falls on the 5th of the month and whose due date falls on the 31st of the month would fill a unique color to cells 5-31. Essentially, this would be like a task calendar. Is this at all possible? any help much appreciated, thanks Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ACCESS ="NO" BUT EXCEL DISPLAYS "0" | Excel Discussion (Misc queries) | |||
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 | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |