Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Reminder On Every Other Friday


Every other Friday, I need to submit my biweekly work hour sheet to manager. For example, as 12/21/2007 is Friday and pay day, I need to submit my sheet. Next time is two weeks later, 1/4/08, and on.
12/21/07 is the first event.

I want to create a conditional format, or workbook events, or worksheet events to remind me on that Friday when I open that book or activate that sheet.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Pop-up Reminder
Macro that automatically runs a task when the workbook is opened. I want it to keep track and monitor the due date so that a Pop-up Reminder can be triggered. By the way, is it possible to display a image as well? Pls take a look at my attachment for better understanding.

View Replies!   View Related
Reminder For Over Due Dates
I have a task follow-up sheet that I have made for my manager, where I need I have a column to set the date when the item is entered or the date the item was discussed in meeting, etc. Then I have an additional column with "due date", here I select the date that the task needs to be completed or the date when I should be getting feedback.

What I would like is to have a pop-up that opens and tells me which tasks are due today. This could happen as perhaps a check everytime that I open my Excel file.

I realize that a conditional formatting can be used, to change the color and highligh items that are due, but I really want a pop-up, this will really make my life easier and communication to my manager easier as well. Plus my manager could use this file without me present. Allowing for less meetings to discuss list.

I have uploaded the sheet that I have so far.

View Replies!   View Related
Reminder Worksheet
I have got a workbook were I register our personnel.
In one sheet I have listed all our personnel and the dates their contracts expire.

Now this is what I am looking for:

Between 15 days and zero daysbefore someone's contract expires I want a pop-up telling me so. The person's name has to be in the pop-up.

I already got this
Private Sub Workbook_Open()
Dim c As Range
For Each c In Range("E2:E126")
If c > -15 And c < 0 Then MsgBox c.Offset(, -3), vbOKOnly + vbInformation, "LET OP! Einddatum contract nadert!"
Next
End Sub

I want the pop-up only when I open the workbook(not everytime I change something in the workbook)

In the workbook are more sheets, the code I have only works with one sheet.

View Replies!   View Related
Automatically Run A Reminder
Our company has a delivery schedule, based on Excel 2003, WinXP. Is it possible to set up reminders (for next scheduled deliveries in a future?

View Replies!   View Related
Pop Up Reminder Listing Cell Then Go To It On Yes
Column B on worksheet3 has a list of dates on it. Column C states set reminder. Column D states how many days before reminder i.e. 3, 7, 10, 14. If the reminder is set to on. Can VBA code be run when the Workbook (or worksheet) that checks this criteria then a pops up is displayed outlining the event (say Cell A)?

Also is it then possible to have on the pop up - Go to this event (i.e. row of data?)

View Replies!   View Related
Reminder When Closing A Workbook
I have 4 employees who at the end of their shifts have to email me an excel workbook. The issue is that some of them are forgetful and after placing numerous post-it notes on their monitors one particular employees just forgets.

What i want to do if possible is that when the workbook gets closed, a pop-up window shows up on their screen reminding them to send the workbook. Even better would be if their was a button that they could click that would email the workbook as an attachment in the pop-up box.


View Replies!   View Related
Automaticaly Show Pop-Up Reminder
i would like to know if Excel offers a feature whereby reminders for instance to call a client will pop up when you open a particular file? I am not referring to the comments tags that one can insert. I am looking for a type of pop up screen function ?

View Replies!   View Related
Reminder: Past Due Date
I want to create an Excel file, which would create alerts/reminders based on dates specified in certain cells. I want to create a database of various events (for ex. Invested in XYZ stock at $10 per share) and put a date in one of the column of each record. I want excel to remind me to take a look at that record after, say, 30 days.

View Replies!   View Related
Reminder Statements Written In The Message Box
creating a MSG box to be placed at the start of the code, i need the following reminder statements written in the message box. If the answers to all statements is Yes then proceed running the code.

1. Is the value date in Sheet Summary Correct?
2. Is the workbook free of errors, check sheet "Errors"
3. Are all the graphs up to date?

Sub Save_File()
Application.ScreenUpdating = False
Sheets(Array("SUMMARY")).Copy
With ActiveWorkbook
.Sheets("SUMMARY").Cells.Copy
.Sheets("SUMMARY").Cells(1).PasteSpecial xlPasteValues
.SaveAs Filename:="S:Recsdata ReportingRec StatsSummary Stats" & Format(Date, "yyyy\MMM") & _
"Stat Summary_" & Format(Date, "dd-mm-yy") & ".xls"
.Close False
End With
Application.ScreenUpdating = True
End Sub

View Replies!   View Related
DATES: Identify Every Other Friday
I have a column that has dates going vertically down from 1/1/2009 - 1/7/2010. I need a formula that will return the date for every other Friday beginning with the second Friday in January 2009.

View Replies!   View Related
Change Non-working Day To Friday
how can i change nonworking date from saturday&sunday to frinday&Saturday

View Replies!   View Related
Calculating Friday Date
I have dates listed in column A indicating the day an action was performed. In column B I need to have the date in column A changed to a Friday. If the date in column A is not a Friday, then the date in column B needs to fall back to the previous Friday. For example, if the date entered in column A is today, Monday August 7, then the date in column B that I would be Friday August 4. Can anyone think of code that determine this and place the value in column B? Currently I use vlookup to go to another sheet where all the possible dates are listed with their respective Fridays, but this slows down the calculation worksheet as the file is quite large.

View Replies!   View Related
Return Last Friday From A Given Month
Re: Return last Friday from a given month
This will calculate the last Friday of the month in which the date in A1 falls:

=DATE(YEAR(A1),MONTH(A1)+1,0)+MOD(-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-2,-7)

HTH

TJ

actually this thread is closed. I want to convert this into UDF but not able.

View Replies!   View Related
First Monday, Thursday, And Friday Of Month
In cell A1 I have a date (like 8/1/08)

In A3, B3, and C3 I need to have the first Monday, Thursday, and Friday of the month. Here's the caveat, I need A3 to have the day that comes earliest in the month.

In this case, A3 would contain 8/1/08 since it's the first Friday, B3 would have 8/4/08 as the first Monday, then C3 would have 8/7/08 as the first Thrusday.

If A1 contained 7/1/08 then A3 would have 7/3/07 as the first Thursday with Friday and Monday following.

View Replies!   View Related
Generate A List With The Date Of Every Other Friday
On my timesheet, there is a button that, when clicked, allows you to select a pay period end date. Our pay periods end every other Friday. When the button is clicked, it opens a form I designed that has a listbox that I manually entered every pay period for the year into. Here is the code I used:

Private Sub UserForm_Initialize()
' Populate the ListBox control.
listPayPeriodEndDates.AddItem "04/03/09"
listPayPeriodEndDates.AddItem "04/17/09"
listPayPeriodEndDates.AddItem "05/01/09"
listPayPeriodEndDates.AddItem "05/15/09"
listPayPeriodEndDates.AddItem "05/29/09"
listPayPeriodEndDates.AddItem "06/05/09"
listPayPeriodEndDates.AddItem "06/19/09"
listPayPeriodEndDates.AddItem "07/03/09"
listPayPeriodEndDates.AddItem "07/17/09"
listPayPeriodEndDates.AddItem "07/31/09"
listPayPeriodEndDates.AddItem "08/07/09"
listPayPeriodEndDates.AddItem "08/21/09"
listPayPeriodEndDates.AddItem "09/04/09"........................

What I'd like to do instead is have VBA populate the listbox (or combobox or what have you) dynamically, by using a reference point (say, the first pay period of the year) and then populating every other Friday from that point forward. Also, it would be great if it could reference the current date as to only list pay period end dates in the future (or even the two prior to todays date, and then maybe 3 or 4 pay period end dates in the future).

View Replies!   View Related
Calculate 1st Tuesday Or 3rd Friday Of Month
I am trying to construct a schedule of tasks to be done by certain dates. If the last day of the month is entered (say 11/31/09) in a cell, is it possible to find out the date for the third Thursday of November or the first Wednesday or the last Friday?

View Replies!   View Related
Formula Return Following Wednesday Or Friday Date
Need a formula for cell J27 that returns the date of the following Wednesday from a date in cell J2 that's a Wed, Thurs, or Fri
or
return the date of the following Friday for a date in cell J2 that's Sat, Sun, Mon, or Tue.

For example, when 05-29-08, a Thursday, is entered in cell F2, I need cell J27 to return the following Wednesday's date of 6-04-08.
or
For example, when 06-01-08, a Sunday, is entered in cell F2, I need cell J27 to return the following Friday's date of 06-06-08.

View Replies!   View Related
Run A Macro Automaticly On A Closed Work Book Every Friday
Is there a way to run a macro automaticly on a closed work book every Friday ? I've found ways of doing this using on-open event but It made me wonder if this was possible.


View Replies!   View Related
Change Cell Color If Date Equals To Friday
is there anyway I can do a conditional formatting of something like that to color a cell if the date in the cell is a friday?

Dates will appear in a column like this:
16-mar
17-mar
20-mar (this is a friday, it should be red)
21-mar
21-mar

View Replies!   View Related
Counting Number Of "Friday"s In A Range
I was wanting to count the number of Fridays that appear in the range of 1 Jan 2010 - 31 March 2010. I will be changing the searchable day and range in the future so I need it automated. I expect the output to be a number, example. 13.

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved