Pop up alert when due date is reached / link cells of different sheets to one "main" sheet within same workbook

NinaMountains

New Member
Joined
Jul 9, 2019
Messages
1
Hi! This is my first time posting a thread so please be nice to me .. :cry:

I have a workbook with 11 sheets - sheets 1-10 have Due Dates (E7 - E50 = reserved for the due dates even though some sheets only have 3 rows filled with dates). Sheet 11 is supposed to be like a main/front page with a summary of the "Overdue" or "Close to being due" tasks from the other sheets. Is there a way to link them to the one sheet? Or a way for them to show up only if they are due/close to being due? (I was going to add the a "today" date in one of the cells on sheet 11)

I would also love to have pop ups for the tasks (tasks from all sheets!) that are overdue. I have no idea how to create that or if it's even possible?

And last but not least, I have a "completed on" column (G7 - G50 = again, not all cells will be used/might stay empty). Would it be possible that the completed by (date) basically erases the overdue pop up alert? So like once the "completed on" cell e.g. G8 is filled (because the task has been completed), the overdue alert/pop up for cell E8 will be suppressed and won't show up even though the due date might be past today's date (but because it has been "marked" as completed with a date, the alert won't apply)?

Sorry for all these questions.. and please let me know if I don't make sense .. I've been trying to work on this workbook for quite a while now and you have no idea how many things I have googled. :rolleyes:

THANK YOU!!!!
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,127,405
Messages
5,624,574
Members
416,036
Latest member
eloisa manzanarez

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top