Activity Reminder from Excel Column

[Closed]
Report
Posts
1
Registration date
Monday January 21, 2013
Status
Member
Last seen
January 21, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I would like to reserve a column "B" on an excel spreadsheet to put a date in the field for "Next Activity Date". Then put the date in the column. Many cells in the column will be blank. Then, I would put a date at the top of the sheet in Cell "B1" to put in the date desired (normally today). I will enter the date manually.

When the date in cell "B1" = the date of any cell in column "B", then I want to create a printable reminder that includes the contents of the cell in Column "C" that is adjacent to the cell with the targeted date in Column "B".

I want to have lots of entries in Column "B" and then get a list of my activities that are in Column "C" that need to be completed on the Date input into "B1".

Can this be done in excel?


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
yup can be done in excel using a macro
SInce I am a total novice in this area is there some way I can contract with you or someone else to write the macro?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
please post a sample book of data as it is now, and how you would like it to be at some public file share site likes speedyshare.com and post back link the the actual file back here. you can use that file to explain again