Previous Topic Next Topic

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 4478 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?


Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 23, 2013 at 07:02 AM
yup can be done in excel using a macro
0
2RGarry
Jan 23, 2013 at 11:55 AM
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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses