I have an excel schedule chart with the first row being consecutive dates for
a month, and multiple rows below containing colored cells indicating
different tasks to be performed on certain dates. As the users create or
revise the colored cells in a row (i.e. number of days scheduled for a task)
I'd like to have the corresponding date or range of dates from the first row
copied to a column on a separate worksheet for export to an Access database.
Is there a way to do this in code? I've been trying HLookup but it doesn't
seem to work quite right. Maybe something that starts with a
Worksheet_Selection Change event?