Activity Reminder from Excel Column

Closed
2RGarry
Posts
1
Registration date
Monday January 21, 2013
Status
Member
Last seen
January 21, 2013
- Jan 21, 2013 at 08:44 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jan 23, 2013 at 09:39 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jan 23, 2013 at 07:02 AM
yup can be done in excel using a macro
0
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?
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jan 23, 2013 at 09:39 PM
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
0