Notification based on a date value

Hi all.

I have a spreadsheet that i use to keep track of my sales accounts.
On that sheet I have dates that actions need to be done.
I'm trying to find out if there is a way of either creating some sort of notification, that would appear when i open the sheet, or that could transfer the information to another sheet that i can then use as a to do sheet.
Lets say A4 is the name B4 is a created date C4 is project D4 is Type E4 is an action date F4 is the action to be carried out G4 is status H4 is date status changed I4 is Value and J4 is turnaround. Column A is constanly increasing as i add more names (accts) to the sheet. The date I am focusing on is in column G, is there a way(s) of doing this?

Suggest you change the subject before a moderator comes along as noone can answer your problem until you do.

Rule 1
https://www.excelforum.com/forum-rul...rum-rules.html

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

konskrypt, since you have broken two rules in this thread, please take the time to review our rules. There aren't many, and they are all important.

Your post does not comply with Rule 8 of our Forum Rules: Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you must provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (most other forums have the same rule).

Please add a link to your MrExcel post.