G
Guest
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
today’s 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
today’s activity
and print it in column 2 of the report? What happens if today’s date
appears twice in Column C?
Thank you in advance for any ideas you can offer.
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
today’s 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
today’s activity
and print it in column 2 of the report? What happens if today’s date
appears twice in Column C?
Thank you in advance for any ideas you can offer.