Computer Support Forum

Auto reminder in excel

Question: Auto reminder in excel

I have ordinary excel table with formulas and dates.When formula in cell fill up another cell with notification "SendReminder" i need to cell send me notification on e-mail. I need also to macro runs even when table is closed. Thank you

More replies
Relevance 100%
Preferred Solution: Auto reminder in excel

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 79.54%

Hi guys,
I have a list of some certifications and their respective expiry dates written in Excel sheet. What I want is to be getting Auto reminder few days before, on and after the expiration date.
Attached is the VBA program that I tired to use but it was reading the whole data instead of being selective. Also attached is an extract of the excel sheet.
Pls I will appreciate any help
Thanks,
CJ
 

Answer:Auto Email reminder from Excel

Have you read the Thread under yours -
http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
 

1 more replies
Relevance 78.72%

Hi Guys,

I have just joined this forum, I found some solutions given by Zack quite useful to me. Thank you so much.

But also need help in taking it further, as I have created a worksheet with lots of data which will have to be incorporated while sending auto email reminders to various admin officers depending on the dates, especially for Statutary payments like Telephone, Electricity etc.

If any body can help....... Please...............
 

Answer:Auto Email reminder from Excel Sheet

http://forums.techguy.org/business-applications/773873-how-make-excel-send-email.html
 

1 more replies
Relevance 78.72%

Hi everyone,

I have no prior experience with Macro/VBA and would need help in creating an excel spreadsheet where an email reminder would be sent 60 days, 30 days and 7 days respectively if the project is not completed to the email stated in the 6th column with information from its row. If its completed, the checkbox would be checked and no mail will be sent.

The email should look like:

To: <email stated in that row>
Subject: Reminder to complete project within (e.g. 60 days)

Body:
Dear all,
Reminder to complete IN1661234 by 31st Aug 2016.

<personal email signature>

Do I need to create a button where I have to click in order for those reminders to be sent or will it be sent automatically everyday as long as the spreadsheet is opened?

Also, is it possible to create 3 different email template for each reminder days, such as 60 days prior to the deadline, the subject of the email would be First Reminder, 30days would have Second Reminder and 7 days prior would have FINAL REMINDER and a urgent marked on the email?

And how do I change the email where those reminders will be sent from?

Any help with regards to the above would be greatly appreciated. Thank you so much.
 

Answer:Auto Email Reminder from Excel when project is almost due

16 more replies
Relevance 77.9%

GOOD DAY, NEED YOUR KIND ASSISTANCE TO THE FORMULA I MAY FORM TO SEND REMINDER E-MAIL TO MY CLIENTS IF ONE OF THE 3 COLUMNS CONTAINING DEPOSITS DUE DATE IS WITHIN 1DAY AND NOT YET BEING PAID.THANK YOU

Answer:Excel 2013 auto sending of reminder e-mail

This cannot be achieved with a formula you will need a macro. The requirement is fairly straight forward but we need some more information to be able to produce this. How is your workbook laid out? we need to know1) which cell has the dates in it2) which cell has the email addresses to which you want the email to be sent3) what the email body and subject will be Also please note writing it caps is considered shouting, please don't type in caps.

3 more replies
Relevance 77.9%

how to set auto reminder when a due date is reached mentioned in excel EVEN WHEN EXCEL IS SAVED AND CLOSED?
 

More replies
Relevance 77.08%

Hello Friends,I am leading the finance team. I need to create an excel worksheet which tracks all my invoices raised on different clients alongwith the due dates. I want excel to send an auto email to client after 2 days of due date and second reminder after 7 days or so.I am from finance back ground and thus do not have any idea of running any codes or macros.Can any body help me with this on priority basis?Thanks and regards,Manish

Answer:Excel worksheet to send auto email reminder to clients

Try here:http://www.rondebruin.nl/sendmail.htmLook under the section: Add-ins and Worksheet TemplatesMIKEhttp://www.skeptic.com/

2 more replies
Relevance 59.86%

Hi everyone. I am currently setting up a database that will hold employer contact information. This document is going to be used to keep track of when a person called the employer, the part that will require some effort and code is setting up a reminder. In this database I need to add a counter or some form of counter that keeps track of how many days its been since the employer has been contacted.

So in one field we have a spot left for Date Contacted. So based off of the information in that Date Contacted, say I contacted an employer today, what I need is for that counter to basically automatically send someone an email when its reached a predetermined amount of days since that employer has been contact for arguments sake lets just say 5 days.

IF anyone can help me with this I would be grateful, Im not very MS access savey. Currently I am working off of MS Access 2003.
 

Answer:Auto-email Reminder

16 more replies
Relevance 59.04%

Hi....
Anyone can help me to advice how do i write VBA for auto email reminder for due dates.
I have tried one from internet guidance but it doesn't work.

i want the email reminder to a list of IDs before 60days and it's much helpful if the program can send the email without opening the excel sheet.

please help.
i have attaced the file.

thank you so much.
 

More replies
Relevance 57.81%

I had made one excel to send automatic due date reminder mails via Groupwise (made with the help of your forums only).
The problem I am facing is as below:
[Also note, problem is not whether Groupwise or Outlook, problem is its generating multiple emails for each due item]

This is generating multiple emails and even the items not due are generating blank mails.
I would like to generate only one mail with different items different expiration dates.
After that group the identical addressees and compose one message with all the relevant data.

Right now its sending 3 mails as:

Mail 1: Please take notice of the following expiration date(s):
-Equipment A Job aaaaa expiration date : 19-Aug-12 -394 days.
-Equipment A Job aaaaa OVERDUE : 19-Aug-12 -394 days.
Sent at 17-Sep-13 11:11:04 AM

Mail 3: Please take notice of the following expiration date(s):
-Equipment C Job cccccc expiration date : 19-May-13 -121 days.
-Equipment C Job cccccc OVERDUE : 19-May-13 -121 days.
Sent at 17-Sep-13 11:11:04 AM

And the ones not due, going blank, i.e: the mail body (Mail 2) text reads:
"Please take notice of the following expiration date(s):
Sent at 17-Sep-13 11:11:04 AM"

What I wanted was a single mail with following in the mail body (Example):

" Please take notice of the following expiration date(s):
-Equipment A Job aaaaa expiration date : 19-Aug-12 -394 days.
-Equipment A Job aaaaa OVERDUE : 19-Aug-12 -394 days.
-Equipment C Job cccccc expiration date : 19-May-13 -121 days.... Read more

Answer:Request Help: Further study on Auto-mail for due date reminder

10 more replies
Relevance 57.81%

Hello Friends,I am practical student. I in process to complete my mini project during internship. I need to make a auto reminder in outlook by using excel when due date arrived. It is one of challenging task because I am student in Major business and minor in IT.There are a lot of coding I'm try.But still not success.I hope can learn more. I also love to learn new thing.I hope somebody can help me to complete this task before I finish my practical training. Thanks and regards,Zulaika

Answer:How to send auto reminder in outlook if due date arrived?

Can you clarify something pleaseAre you looking to have a number of dates in Excel, which when reached/passed Excel is to create an email via Outllook and send it to someone?Can you provide an example of how your workbook is laid out

2 more replies
Relevance 57.81%

Hello Friends,I am practical student. I in process to complete my mini project during internship. I need to make a auto reminder in outlook by using excel when due date arrived. It is one of challenging task because I am student in Major business and minor in IT.There are a lot of coding I'm try.But still not success.I hope can learn more. I also love to learn new thing.I hope somebody can help me to complete this task before I finish my practical training. Thanks and regards,Zulaika

More replies
Relevance 55.76%

Hy there,

Can some1 help me code a script that will send an e-mail reminder with one date before the DUE DATE based on the date that is in excel. Prb is that i have more the 1 sheets and the date is not always on the same column.

Thanks.
 

More replies
Relevance 55.76%

Hi, Its my first post here. I need to send reminder mails from outlook based on excel
I searching for the VBA which according to my needs and I find in this Forum, but I have difficulty understanding. VBA that I adjust not functioning.

I attach the following

I need your expert solution

Any help appreciated and thank you.
 

More replies
Relevance 55.76%

I have searched and read the topics on this, however I am apparently below beginner and need someone to walk me through the entire process. I need an email sent to myself and 2 other co-workers one day before an item listed in my spreadsheet expires. I have the expiration dates are listed in column F. I have not entered any email addresses yet.I would like, as I have read in previous threads, for the system to open and check itself daily. Any help is greatly appreciated, and I will need a very basic, step by step hand holding description.
 

Answer:Excel Email Reminder

Hi, welcome to the board.

I suggest the following link, there enough information and samples there too.

http://www.rondebruin.nl/sendmail.htm
 

2 more replies
Relevance 55.76%

Hey Guys,

I need some help getting an on-screen (pop-up or message dialouge) reminder based on date entries in my excel workbook. I have gone through other posts suggesting methods to get an Email as reminder, but could'nt figure out how to go about for an on-screen message.

I need a message listing all tasks which have two days left for completion. This should carry on even if the date is passed untill I change the date entry for a particular task.

I wish to have this message at user logon automatically, so will schedule execution of a VBS file which I could find from an earlier post by Zack.

Will be gratefull! for your help.
Thanks.
 

More replies
Relevance 55.76%

Hi All!

I have a list of events and dates for those events and I need to create a system that will email cetain people when those dates approach. I have done a little research but cannot figure out how to make it work. Please help me! LOL Thanks!
 

More replies
Relevance 55.35%

I am working on a long list of temporary employees hired with "termination" dates. These dates vary. I want a reminder set to 5 days before the listed "term" date so it alerts me with a reminder. I have seen many different formulas and they work.

The problem I'm having is that there is a long list and that is a "continuing" list...so there are many blank rows. Currently I am using both conditional formatting to highlight it and I'm using the IF formula:

=IF(I2<TODAY()+5,"REMINDER","")

The problem is that it is filling in REMINDER for all of my "empty/blank" rows. I do not want it to appear other than where the data is, but I don't want to have to remember to carry the formula down. So right now I have about 22/23 rows that are filled. I want to expand my spreadsheet out to about 600 rows. But everything past the 23 rows is showing REMINDER even though there is no data in those rows. Is there something I can do to have it carry through the 600 rows, but not put in the reminder until there is data in there telling it to send a reminder? I'm using a MAC with Excel 2017. Thank you for any information.
 

More replies
Relevance 55.35%

hi there,

I have a list of memberships that need to be renewed at different dates (eg. every two or three years depending on type of membership)

Is there anyway i can make it to automatically send an email to remind me or another person the day it's due to renew?

The list is on excel with expiration date in one of the columns
thanks
 

Answer:Set email reminder based on excel

Hi, take a look at some of the posts, there are quiet a few that do just that, they may need a little editting for your purpose but...
Here's a simple module that does just that, all you need to do is wriet a amcro that fills in the blanks

Code:

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, Sendto As String, CCto As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)

With Itm
.Subject = mSubject
.To = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Function


P.S. You forgot to mention the Excel versio you're using
 

1 more replies
Relevance 55.35%

Hello Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is nearing 3 hours, 2 hours & 1 hour away from the current date & time. The script should preferably run automatically every time the PC is running when the excel file is open.

In the attached excel file, An email should go of to -email address (Col. F), with subject "number (Col. B) is due on Due date and time (Col. E)", and body "Dear Name(Col. F), please finish your project asap".

Also, the script should put a check mark on Reminder sent column (Col. G) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

Answer:Automatic Reminder email from Excel

Hi, I suggest you do some searching, there are quiet a few posts with the same questions and the necessary solutions.
I worked on one or two but cannot remember the names, so just do a quick search and you'll find the answres with the necessary code.
Always to glad to help on if you're still stuck
 

1 more replies
Relevance 55.35%

I have a list of task (maintainance schedule) to do... and they are required to be done in a by certain different dates regularly (eg. every 14 days or every 28 days)

I have a specific maintance date for each task within the same row. Is there anyway i can make it to automatically send an email to remind me or another person a day before it's due??

thanks
 

Answer:Set email reminder base on Excel

16 more replies
Relevance 55.35%

Hi,
I'm kinda new to VBA and excel programming and am looking for a way of sending an automated reminder 60 days before the expiry of training already completed. column G contains the email recipients, Column E has a title Asbestos Awareness and the cells in column E the expiry dates for employees.
I would appreciate if anyone has sample code I could try.


Thanks sooooooooooo much for any help or advice.
Regards
Vinny
 

Answer:Automatic Email reminder in excel

Hi Vinny,
welcome to the forum, you're the second one this week with the same question, and just like the other poster I do not think you took the time to search for similar posts.
I suggest you do hat, there are several posts with the similar questions and also with the answres and code provided.
 

1 more replies
Relevance 55.35%

Hello there,

First time posting and very average excel capabilities... Working on generating a code that will send automatic email reminders 7 days prior to the date within rows F-P. Recipients contact information is in column S.

Thanks for your time.

Tim
 

More replies
Relevance 55.35%

I have a real simple need. Well, it's probably simple for some. I have a sheet built to track employee hire dates and eval dates. I would like to assign excel to open everyday at a time and then evaluate the cells with the eval and raise dates to see if an email needs to be sent to the supervisor. If so a simple "there are employee items coming due" email is sent to the supervisor. The super will go to the document and take care of the rest. Dta is not real. The email with the employee name isn't the one I'll be sending to. The Team Manager at the end is where the email will be going to for all on the sheet. I would appreciate the help. Running windows 7 and office 2013.
 

More replies
Relevance 55.35%

If I am doing an automatic email reminder when something is past due:

do I always have to open the Excel document for the macro to run and the reminder to sent out?

Thanks,
 

More replies
Relevance 54.53%

hi there,

I have a list of memberships that need to be renewed at different dates (eg. every two or three years depending on type of membership)

Is there anyway i can make it to automatically send an email to remind me or another person the day it's due to renew?

The list is on excel with expiration date in one of the columns
thanks
 

Answer:Solved: Set email reminder base on Excel

you have another thread here
http://forums.techguy.org/business-applications/1055728-set-email-reminder-based-excel.html
please do not duplicate posts - closing this one
 

1 more replies
Relevance 54.53%

For some reason there is a problem with this programme I have built (with help from Computerman) now I have transferred it to another excel file.

When I try to set a Callback Reminder (my terminology), once I have entered the details an error comes up for some reason. The programme has been tried and tested by itself and worked brilliantly but for some reason it doesn't now.

Please use password lfc1979 on the login screen
 

Answer:Solved: Excel outlook calendar reminder

9 more replies
Relevance 54.53%

Hi

This is a tuffy........

I want a macro so that when i type a message into a cell it will put it into outlook as a reminder, or even a simple macro button that opens outlook in the scheduler.

Any ideas?

Thanks
 

Answer:Excel macro links to Outlook Reminder

Try this link.
 

1 more replies
Relevance 54.53%

This is my first time posting on here so I hope this is the right place.

I have attached a spreadsheet I will need to populate and we would like to send staff members an email reminder before they need to do their task. Maybe a day or the morning of the day is fine, as long as they get the reminder. I was just wondering how I would go about doing that?

As the Excel file would need to be opened in order to work , I was also wondering how I would be able to set it to open on the start up of everyones machine. Even if it can only start up the programme then it will be obvious to people what they need to open.

Could the email or subject include as much info as it can. Like name, company, job title and contact number. and for it to be sent to the Asignee.

We will then change the next contact date once completed.

Any help would be appreciated!

Thanks
 

More replies
Relevance 54.53%

Hi, this is my first post here and I will preface this by saying I am not familiar with VBA/VBScript language at all (only that it exists and perplexes me), which is why I'm requesting your help!
I have an Excel spreadsheet that I'd like to have send me an Outlook email reminder 6 months after the specified start date, without having to open the Excel file so the macro can run. The reminder email can be simple, just a short message like "Referral Alert: Check Spreadsheet"

I've attached a test file with the columns needed highlighted in yellow.

If this is too tall of an order, I understand!
 

Answer:Send Outlook reminder on specified dates from Excel

As far as I know, this is impossible in the given scenario. Macros only run once a file is loaded; therefore, not having the file loaded means any code won't execute.
 

2 more replies
Relevance 54.53%

I would like to ask for an Excel macro which can send an automate email on a certain date every Month.

The dates would be as follows:

1st Monday: Email should be sent to [email protected] automatically
2nd Wednesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically

Subject line: ABC123D5679_Data transfer expected today

Details of the body of the text message:

"Dear All,
This is to remind you that we are expecting the data transfer to be posted in Novartis system today . This is just an advanced intimation.

Kindly let us know if you foresee a delay in the data transfer.

Kind regards,
Rohit"
Many thanks in advance for your help guys. This means a lot.
 

More replies
Relevance 54.53%

Using Excel: I need to send one email reminder to participants three months after they sign up.
This is only done once.
I need to mark a field "sent" after they have been sent this reminder.
The next time I check for people needing a reminder those marked "sent" will not be sent another reminder, only those who have not been marked "sent".
Thanks for the help.
 

Answer:Solved: Excel send reminder and mark it was sent

Hi, welcome to the forum:
Code:

Option Explicit

Sub SendUpdate()
Call MailData("subject string", "status file updated", "[email protected]")
End Sub

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)
With Itm
.Subject = mSubject
.to = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
.Save ' This property is used when you want to saves mail to the Concept folder
' .Display ' This property is used when you want to display before sending
' .Send ' This property is used if you want to send without verification
' .Attachments.Add (Filename) ' Must be complete path'and filename if you require an attachment to be included
End With
Set app = Nothing
Set Itm = Nothing
End Function

You will of course have to add your macro to send the mail and then enter a true or false in the sent column

A handy link to use ... http://www.rondebruin.nl/sendmail.htm
 

3 more replies
Relevance 54.53%

I have a list of jobs (jobs schedule) to do... and they are required to be done in a by certain different dates regularly.

I have a specific jobs date for each task held in a colu. Is there anyway i can make it to automatically send an email to remind me or another person a day before it's due??

Another question - I have a basic dashboard when a job is overdue I want the cell to flash RED

thanks
 

Answer:Set email reminder based on conditions on Excel

10 more replies
Relevance 54.12%

Hello.
I have been asked to send warning e-mails to a short list of adresses from an Excel file where reminder dates correspond to the actual date, and I have no clue how to do this with Macro’s. I’v tryed to understand how some examples of macros dealing with Excel and e-mails with no success as I still have a lot to learn…

Here is my problem : I have a spreadshhet containing company names (col.A) and contract renewal dates (col.D). there are about 80 companies listed. When the actual date corresponds to the reminder date an e-mail containing the company name, a fixed blabla and the reminder date should be send to 3 known e-mail adresses.
Could this be done with an Excel Macro
I’m using Windows 7 32bits, Office 2010 with Outlook as mailing system.

Many thanks in advance.
Robert
 

Answer:Solved: Reminder date in Excel sends an e-mail

16 more replies
Relevance 54.12%

Hi lovely people!

I hope you can help me out - I'm new to macros. In regards to the attached excel file, I need to achieve 3 main goals:
Automated pop-up message - For each phone that is overdue for delivery (ie current date is more than due date), I need a pop-up message upon opening the excel sheet. The pop-up alert should say which phone is due (stock #), and how many days overdue it is (current date minus due date)
Automated email reminders - emails to send to various email accounts (individuals in my team) to remind them of overdue phones. The email should include details like the phone, stock #, supplier, due date and how many days overdue. I want the first email reminder to be sent on the due date itself, then 2nd reminder on the next day, and subsequent reminders every 3 days.
Have a separate sheet listing all the overdue items that need to be followed-up.

Lastly, but is it at all possible to create two versions of the same stock list? I.e. one sheet in English, and the other sheet in French. And any edits in either sheet will update the other version.

Cheers!
 

Answer:Excel help! Automated pop-up box and email reminders, and reminder list

Hi, welcome to the forum.
Have you doen a search in this forum.
There are many posts that relate to triggering a mail message based on calculations and expiry dates, etc.
You will of course need to edit some solutions for your purpose, but I do suggest you take a look (search) and probably you'll find what you need.
The question about the two languages is custom macro coding and will take some time.
Your sample contains onle one row of data, but nothing more to go on.
Do some homework (searching the forum) and someone will be able to help
Please don't forget to mention the Excel version, as far as I cansee it's at least version 2007 but it could be 2010 or newer
 

1 more replies
Relevance 54.12%

hi !
I have a spread sheet of 100 of employees , i like every time the expiry date come for there id a notification email come to me , i attach the example excel sheet please help me with that, i am just learning VBA not very good in it i am using windows 8
 

More replies
Relevance 54.12%

Hello Everyone!

This is my first post here. I am using Excel 2013 OS win 7. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is nearing 3 hours, 2 hours & 1 hour away from the current date & time. The script should preferably run automatically every time the PC is running when the excel file is open.

In the attached excel file, An email should go of to -email address (Col. F), with subject "number (Col. B) is due on Due date and time (Col. E)", and body "Dear Name(Col. F), please finish your project asap".

Also, the script should put a check mark on Reminder sent column (Col. G) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

Answer:Automatic Reminder email from Excel 2013 in Windows 7 pc

closing duplicated post
continue here
http://forums.techguy.org/business-applications/1141421-automatic-reminder-email-excel.html
 

1 more replies
Relevance 54.12%

Hi:
I am very new to Excel 2007 and macros. I have a spreadsheet that I am trying to get to send an email reminder to the point of contact [ col b ] 5 days prior to the closure document due NLT date [ col m ]. I am looking for assistance in writing a macro which will accomplish this if it is possible. I have attached the spreadsheet that I referenced.
Your assistance would be greatly appreciated.
Thanks in advance.

desantisj
 

Answer:Excel 2007 Macro to Send Reminder Email

desantisj, welcome to the Forum.
There are already 3 or 4 posts on this forum that have the VBA code (Macro) that you can modify for your Workbook if you can read the code. Zack has written the code so it is a bit complicated, but it should be a case of substituting your Cell references that hold the data for the ones that others have used.
Otherwise it is a case of waiting for an Excel guru to come along and help. If none of them come along I can probably help you, but I normally work with Access.
 

2 more replies
Relevance 53.71%

Hi,

i have used the following to get automatic alerts setup when a due date is near:
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

but instead of this looking at the due date column, i would like it to look at a conditonal formatted column, which shows status as either "due" and "expired" depending on due date. i would like it send out to all those with "due tag and not "expired"

I have name in column A, details in column B, emails address in column C, status in column i, and reminder in column k
Somethng else i would like to do later on, if at all possible,is to get a particluar email from outlook be transfered to excel and and then emailed to specific people based on a status column. So if an email is recieved to say a project is extended or cancelled,, it contents is copied to excel and emailed back out to certain people.
Thank you for your support.
 

More replies
Relevance 53.71%

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-applications/710581-solved-automatic-email-alerts-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

Answer:Automatic Email Reminder from Excel based on Date in Cell

Please do not post duplicate threads.
One thread per issue.
Continue replies for this issue in this thread: http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
Thank you.

Closing thread.
 

1 more replies
Relevance 52.89%

Hello all,

I'm receiving mail alert based on date only, it is not considering the month into the account.. Kindly suggest..

Attached the excel file with macro...
 

Answer:Automatic Outlook mail due date reminder based on Excel file

16 more replies
Relevance 52.89%

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a payment is 10 days away from the current date. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. Q), with subject "Vendor Payment (Col. C) is due on Due date(Col. M)", and body "Dear Name(Col. P), please update the payment status".

Also, the script should put a check mark on Reminder sent column (Col. Q) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scored the forum for similar problems, and although I found a number of threads, I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

Answer:Automatic Outlook mail due date reminder based on Excel file

15 more replies
Relevance 52.89%

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is 7 days away from the current date. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. D), with subject "Project (Col. B) is due on Due date(Col. C)", and body "Dear Name(Col. A), please update your project status".

Also, the script should put a check mark on Reminder sent column (Col. E) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,

Thanks
 

Answer:Automatic Outlook mail due date reminder based on Excel file

8 more replies
Relevance 50.84%

In excel 2010, I entered "=HYPERLINK(VLOOKUP(B3,CTO_DB!A1:B1001,2,0),B3)". How can I make it auto open the file if hyperlink is exist? Thanks

Answer:Auto open word, excel and pdf file in excel

It is a bit complicated, using LOOKUP with HYPERLINK,see here for an explanationhttps://stackoverflow.com/questions...MIKEhttp://www.skeptic.com/

4 more replies
Relevance 50.84%

Im wondering if it is possible to do this before i start trying...

I recieve an email containing an excel sheet containing several peices of info such as:
Name
Surname
ID
Etc Etc... Now when i open this.. i need the information posted into specified columns in a new excel document where it will have
NAME | SURNAME | ID |
-------------------------------------------
STEVE NORTH 01874
Any help given appreciated.
 

Answer:Excel - Auto export data into specified excel sheet

6 more replies
Relevance 50.02%

PREVIOUS REQUEST - http://www.computing.net/answers/office/excel-to-word/10126.html.Assistance given by Derbyday03 and HumarBack again with the gatepass situation. Sorry didn't get back last time, this was due to major changes in the organisation/job shuffles and the vehicle entry proceedures (which coincidentally, have now change back to what it was LOL)A few changes now in our request. Word document changed to an excel document.Overview: As a vehicle arrives it is booked in on an excel sheetDate in A5 and every vehicle book in on at line i.e A7 to F7. This will be time, veh reg, etc..and the info saved.This then needs to be sent to a gate pass sheet in the same worksheet which is made in to a vehicle pass and printed off.The information needs to be placed in cells of the gate pass sheet as follows:A5 to C2, A7 to E2, B7 to C3, C7 to E6, D7 to C4, E7 to E5, F7 to C6.Once on the sheet a shortcut to print the sheet off and then clear irself ready for the next vehicle information.Is this possibe....

Answer:Auto live transfer from excel to excel

re: This then needs to be sent to a gate pass sheet in the same worksheet which is made in to a vehicle pass and printed off.I assume you mean "sent to a gate pass sheet in the same workbook" since you can't have a "sheet in the same worksheet"From your description, it seems pretty straightforward...If the data entry sheet is named, for example, "Vehicle Info", and the gate pass sheet is named, for example, "Gate Pass", just use:=Vehicle Info!A5 in Gate Pass!C2=Vehicle Info!A7 in Gate Pass!E2etc.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 45.51%
Question: Excel auto sum

Why I am just going the value in the cell and not the sum of the numbers ? I have excel 2013
how do I fix this?
 

More replies
Relevance 45.51%
Question: Excel Auto Sum

In excel when I have a row of numbers and I click in the empty cell below the numbers and click the auto sum button it starts a formula for me. It wants me to fill in the first cell address: and the last cell address. How to I get it to total without me entering the formula. I know it has worked before. I am trying to help someone who is very New to excel and I want to stay away from formulas for now. I just want he to be able to total a column easily. Thank you
 

Answer:Excel Auto Sum

8 more replies
Relevance 45.1%

I have a sheet that have auto updated prices from the net. can I set a task to action at certain times of the day so it copies the data from one form lets say at 10:00pm daily it grabs the data from form1 cell a1 and pastes it to form2 cell a1 then the next day it grabs the data from form1 cell a1 and pastes it to form1 cell a2.

More replies
Relevance 45.1%

Hi,
my problem is the wrong answer for auto sum. for example,
A B
1 2
1 3
result 2 2 -->using Auto sum function
cell B3 the result should be 5 but result is = 2
However, the result will be correct after i save the file.
what wrong with this formula? Is the file has a virus? I scaned Virus but can't detact it.
please help me
thx,
 

Answer:Excel: wrong auto sum

15 more replies
Relevance 45.1%

is it possible to auto fill an excel cell with simply the name of the sheet (tab) it resides within?

Answer:excel auto fill Tab Name

Try this:=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)You have to save the workbook and then recalculate for the Tab name to replace the #VALUE error.

2 more replies
Relevance 45.1%

I have trouble accessing the file that is saved as an auto save. the pathname of the file on my PC (Win XP) is as follows:

c:\Documents and Settings\Owner\Application Data\Microsoft\Excel

I tried doing a search for this path...no luck.

How can I find these auto saved copies of my Excel document?

Thanks
 

Answer:Auto Save in Excel 02

you should uncheck "show hidden files and folders" on the advanced tab in the folder options - that should allow you to browse to the folder and see those files
 

3 more replies
Relevance 45.1%

I have an excel file that contains several fields, of those fields
I have 2 fields that match and a dr and cr that offsets. I am trying
to create a macro or anything that will work that will take those
matches and store them on separate spreadsheet and leave the records
that have no matching data.

Any help would be appreciated

Thanks
Cipriano
 

Answer:Excel auto matching

All the match will do is return the location of the match from the array or range of cells. You might be able to do this conditionally.
 

1 more replies
Relevance 45.1%

Is it possible to activate an outlook email template automatically whilst working in MS Excel? I dont know if this can be done via VBA or not as not an expert.

E.g if a date in a cell is reached an email template will automatically start?

Or must I work in Access using forms etc to do this?
 

More replies
Relevance 45.1%

Why everytime i tried to close my excel [all excel file], will have one error screen prompt out. Stated "The information you were working on might be lost. Microsoft Office Excel can try to recoever it for you" Then one check box with "Recover my work and restart M. Office Excel" with 2 button below, "Send Error Report" and "Don't Send"

Answer:Excel Auto Recovery

Hi,A number of questions:1. Does this happen if you open Excel and Close it without opening a Workbook (only a new blank workbook open)2.Was Excel working OK before.3 Have you installed any new programs recently. Sometimes programs create add-ins for Excel which cause problems4. Have you checked any add-ins - goto Add-ins in Excel Options and clear all checked (ticked) items.5. Have you written and saved any macros.Regards

5 more replies
Relevance 45.1%

Is there a way to turn off the automatic backing up of files in Excel 2007? I figured it out in Word, but you don't get the same option in Excel.
 

More replies
Relevance 45.1%

Firstly i would like to say hi to everyone and thanks in advance for any advice / help.

Here is my problem...

I have a spreadsheet and it contains a list of our employees and when any of their work related certificates expire. What i would like to do is create a script??? or something that will run and send an email to a selected list of people informing them that a certificate is about to expire.

The spreadsheet is excel format and the email software my work uses is Groupwise.

Also something to note would be that there may be multiple people who have expiring certificates at the same time, would it be possible to send just one email or would individual emails be the only way to go.

I have attached a very simple spreadsheet so you can get a better idea of what i mean.

Once again, thanks guy for any help you can provide.
 

Answer:Auto Email from Excel

why oh why do spamers exist
 

2 more replies
Relevance 45.1%

I would really appreciate some help on the code for auto sorting in Excel

Here is what I keep using to sort:
Column AH, Values, Oldest to Newest
Column E, Cell Color, 0070C0, On Top
Column E, Cell Color, 00B0F0, On Top
Column E, Cell Color, 92D050, On Top
Column E, Cell Color, FFFF00, On Top
Column AC, Values, Oldest to Newest

Any help would be greatly appreciated,

Thomas

Answer:Auto Sorting in Excel

You Tube

1 more replies
Relevance 45.1%

Hi,

Everytime I type in "HSI" in the cell of excel, it automatically change it to "HIS". Same w/ "TEH" to "THE".

How do I prevent this auto spelling checking feature?
 

Answer:Need help in Excel...need to prevent this auto...

7 more replies
Relevance 45.1%

So I've been reading on auto sorting but I'm having a hard time wrapping my head around the concept when it comes to the marco's and punching in the numbers:

So here is my sheet:

Name | Sponsor | Code | Report Date | Date Contacted

I want to sort by the Report Date Column (Column D) from earliest to latest. the table starts a A10 and there are 7 columns (the last 3 columns are merged (EFG)) and 18 total rows to include the header row and ends at G27. What is the macro to auto sort so i can sort via date and add/delete people keeping the same A10-G27 grid?

Thanks
Adam
 

Answer:Excel Auto Sorting Help?

7 more replies
Relevance 45.1%

Hi there

can someone help me trigger auto email from the attached excel sheet ?

The email should be triggered upon the 'status' with corresponding message from 'remarks' column
 

More replies
Relevance 45.1%

I want to be able to enter a number in a cell and have it automatically become a hyperlink to a row on another worksheet in the same workbook. Say I enter "23" then whenever I click that cell it will take me to row 23 of the other worksheet. Thanks in advance.
 

Answer:Excel auto hyperlink to row

I think what you're asking is doable in VBA. But with a little compromise- can be esily achieved with a simple formula. The compromise being that the hyperlink will be an adjacent/another cell and not the actual cell in which you enter the row number for your jump-to location.

Say you enter the the row number you require in cell sheet1!D3, then you could have the hyperlink in sheet1!E3 containing the formula

=HYPERLINK("#Sheet2!" & D3 & ":"& D3,"Row number " & D3)

which would take you to the desired row number in worksheet 2.

Hope this helps. Get get back if you want to rack some brains on the vba solution.
 

1 more replies
Relevance 45.1%
Question: Excel auto date.

Hi!

Is there any way to get Excel, to automatically insert the date into the first cell in column A everytime a new row is inserted?
 

Answer:Excel auto date.

13 more replies
Relevance 45.1%

Hiya,

I have the first letters of the days on a row (eg m,t,w,t,f,s,s….) is there any way I can have this cell, row or column to be highlighted automatically upon opening the spread sheet to select ‘today’s day/date?

Thanks
 

Answer:Excel – Auto date

9 more replies
Relevance 45.1%

hello, I am currently looking for a way to make my excel spreadsheet (That we are displaying in our office on a tv) to auto scroll to the information, stop every five lines and return to the top when it hits the bottom
 

More replies
Relevance 45.1%

I want to make a spreadsheet that helps students calculate the lowest possible value they need to get in 2 remaining quarters in order to pass for the year, but I don't know how to set up a formula for it. Example: Student has Q1: 65%, Q2: 60%, Midterm: 24%, Q3 (so far): 54%, Q4: X, Final:X, and must all average out to 60%. What would my formula look like for a lowest possible value in order to get overall avg to 60? Thank you very much in advance!

Answer:Excel auto-averaging for a set value

Two values will give an simultaneous equation depending upon the weighting.

4 more replies
Relevance 45.1%

Hello.

Seeking help with a worksheet/Sorting question.

I have a three worksheet workbook. The first is a master list of First/Last names, phone extensions and office location and is sorted alphabetically by last name.

The second worksheet pulls name and extension (using formula:=Sheet1!A1) and is sorted by extension.

The third pulls name and office location (using formula: =Sheet1!A1) and is sorted by office number.

If I add a name to Worksheet1 at the end of the list, it transfers into Sheet2 & 3, but is not sorted in the sort defined sort order. I'm trying to figure out how I can enter data into the master on Sheet1 and when I move to sheet2 or 3 have that data aoutmatically refreshed or resorted so that it is in the appropriate sort order.

I am guessing that macros may be the answer, but thought it was worth an expert opinion first.

Thanks in advance.
 

Answer:Excel: Auto Re-sort

Can you please post your workbook or sample workbook showing the structure of the data? It should be a very simple code to add to your Worksheet_Change event.

Rollin
 

3 more replies
Relevance 45.1%

hello,
i am trying to sent out an automatic email anytime the workbook has been changed and for example 3 days have passed from a certain date on the worksheet. this would have to be applied to close to a hundred rows per sheet and would be sent to outlook 2007. not express or anything. wondering if it would require multiple VBA codes or not.
i have looked on the Ron site and many postings but i just found out what a macro was and would love to learn how to write VBA but dont have the time. looking to try and solve this. also need to know if the computer im working on has to have outlook or if i can do it from one that doesnt.
Have an example and any details for further assistance just ask. any help would be greatly appreciated thank you.
 

Answer:Auto email using excel

16 more replies
Relevance 45.1%

Have an excel written sheert. Two columns are for names. There is some sort of auto complete being used and some names fill when typing them in. I can not find the file. I would like to edit it and add some and remove some names. I looked in options and it is not listed there. Help please!! TY
 

Answer:Excel Auto complete help!!

6 more replies
Relevance 45.1%

Hi guy & gals,

I'm a first time poster, but looking through some other threads I thought that you may be able to help me.

I'm quite new to Excel and compared to most of you a complete and utter novice so some help would be vey much appriciated.

I'm in the process of creating a basic spreadsheet that allows us to see when an insurance inspection is due. I am after getting the spreadsheet to automatically generate an email and send it to a set list of emails once the condition changes in a cell. Could you let me know if this is possible and if so, how would I go about doing this?
I'd like to title the emails with No.?? (relevant crane) Inspection due, then in the email put the details in that I have, such as the last date it was completed, the date it's due, if there is a planned date and any requirements.
I have conditionally formatted column B from the TODAY function in cell A1, to change from green to yellow 28 days before the due date, then from yellow to red 7 days before.

I haven't put any email address into the sheet that I have attached, but obvioulsy will do if you can somehow help me sort this.

I am intending just to leave the spreadsheet in a file somewhere and only open it to input data after the emails have being generated.

I have attached a copy of the basic spreadsheet that I am using, as I have said, basic.

Thanks in advance.

GPO
 

Answer:Auto emailing from excel

HI,

Check this site to see it helps.
http://www.rondebruin.nl/win/section1.htm
Once you look it over and you still need help let us know.
 

3 more replies
Relevance 45.1%

Can anyone help with adding (automatically) cells in excel....I'm trying to calculate litres to gallons which is litres (27.05 x 0.22) litres x0.22 gives the conversion to gallons...In this case it would be 5.95 gallons, then the mileage, say 119567, then the mileage taken away from the previous mileage to give a total breakdown of previous mileage.... then MPG, by dividing mileage breakdown by gallons....Price Lit Gall Mile B/Down MPG20.00 26.01 5.72 119647 0 0.0020.00 26.01 5.72 119847 200 34.95I will have to input the price and litres myself but need Excel to automatically calculate the rest... Can anyone help with this....thanks. EOS.

Answer:Auto calculations in Excel

would be for someone to send you an Excel spreadsheet with the computation shown.But you would need to post your e-mail address.

3 more replies
Relevance 45.1%
Question: Excel auto dating

When I type 6-23 in a cell it is converted to read:
23 Jun. How do I turn this feature off. I want the cell to
read 6-23.
 

Answer:Excel auto dating

6 more replies
Relevance 45.1%

I want to convert my .cvs file format to .txt format which will update after 4-5 minutes. when i change values from excel file values in .txt file auto change.
Can anybody please help
 

More replies
Relevance 45.1%
Question: Excel auto format

Hi!

I have recently switched to a new computer using windows 7

In the past, in order to auto format a large amount of cells with a formula and values, all I would have to do was enter the formula in a couple of cells and then click on them and drag.

Now, clicking and dragging put the formulas into the new cells, but the value does not show until I click on each individual cells formula bar and press enter.

Could someone please tell me how to set the auto format so that the value is copied and shown automatically (and not just the formula)

Thanks
 

More replies
Relevance 44.69%

I am looking for a code to auto sort in ascending order some division numbers in column H of my excel sheet. The information that needs to be sorted is located from B9 to H36. I do not want it to sort column A at all.

Answer:Auto Sort Excel Sheet

We need a little more information before we can offer a possible solution.1 - In your first sentence you say "auto sort in ascending order some division numbers in column H." In your second sentence you say "The information that needs to be sorted is located from B9 to H36."So which is it? Column H or B9:H36?2 - What will be the trigger for this "auto sort"?3 - What is in the sort range? You used the words "division numbers" which to me implies formulas. If that is the case, then I believe that the formulas will need to be replaced with the values before the range can be sorted.Perhaps a small example of your data would help. If you are going to post any example data, please click on the following line and read the instructions on how to post data in this forum.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

8 more replies
Relevance 44.69%

I just only a regular excel user, hope U all can understand my question.
 
Every end of month I need to make a image snapshot from a charting system and save it to a jpg file format by overwriting the previous jpg file. Then I insert the jpg picture file (embedded) into a booksheet.
 
1st -  it just only 20 jpgs snapshots task and need to insert to 20 booksheets but now its grew to 50 and growing.
Is there anyway that I can auotomate the jpg file insert task into the booksheet. Some sort like paste a photo link once in the booksheet and leave it for the jpg file update via file overwrite.
 
I tried the hyperlink - it just popup the jpg photo via photo viewer and it needs to click to view. I want something similar like paste link - > external jgp file paste link to Excel. Everytime the jpg file being overwrite, the picture view in the excel also changed. No needs for me to insert.
 
I had thought about to macro the picture insert (embedded) task but I know nothing about macro.
 
Tq.
 
 

More replies
Relevance 44.69%

I am using the forumla =IF(ISBLANK(Sheet1!A33),"",Sheet1!A33) to insert info from sheet 1 to sheet 2. The problem I'm having is if I delete a row on sheet 1, I get an error message of "#REF!" on the second sheet. How can I automatically 'delete' the same row on sheet 2 so I don't get the error message?

Answer:Auto populate rows in Excel

Your subject line says "auto-populate rows" but your question relates to "automatically deleting rows".Confusing.If what you are trying to do is delete the same row on two sheets at the same time, then select both sheet tabs (Ctrl-Click the tabs) and then delete the row from any of the selected sheets.Remember to select only one sheet before you do anything else or you'll do it to every sheet that is selected.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 44.69%

excel worksheetsIs there any way to have excel take you to a specific worksheet when you click on a cell. for instance, if I had cells with Sunday, Monday, Tuesday, etc., and corresponding worksheets with the same names. Can I make it so that, when you click on the Monday cell, it automatically takes you to the Monday worksheet

Answer:Excel worksheets auto send?

What your looking for is the =HYPERLINK() function.Try this:With your Sheet Names in Column A:
A
1) Sunday
2) Monday
3) Tuesday
In Cell B1 enter the formula:=HYPERLINK("#'" & A1 & "'!A1", "Link To "&A1)Drag down.Now when you click the link in Column B, you will be taken to the new sheet,with the cursor in cell A1MIKEhttp://www.skeptic.com/

3 more replies
Relevance 44.69%

there is no autosave function in my excel (version excel 2002) (OS :Windows 98). Please guide me for that?
 

Answer:auto save function in excel

12 more replies
Relevance 44.69%

Hello,
I have an Excel file where I track repairs that are sent out to various repair centers. What I am having trouble with is this: Right now I have a formula that calculates the estimated delivery date based on the lead time and ship date. Works fine. But in the rows where there is no data, the formula still shows. And since there is no start date or lead time entered, I have a long column of 1/0/1900 becuse the formula does not see a start date or lead time. What I want to do is have this not show up until I enter the start date. I need this to work automatically, kind of like how Microsoft Projects works but not nearly as expensive. Any help would be appreciated!
Thanks!
 

Answer:Auto unhide rows in excel

6 more replies
Relevance 44.69%

I work in construction. We'd like to know if there is a way to work a calendar backwards. We have a "due on site" date, a material lead time and need to figure out when the item needs to be approved by in order to meet the "due on site" date.

Please help, thank you for your time.

Katy
 

Answer:Excel Auto Calculate Dates

Hi there, welcome to the board!

Yeah, you can absolutely do that. Dates are serial numbers in Excel, so you can do math on them. The question really becomes where is your "due on site" date located, and how do you want to calculate the approval date? Is this just a set number of days prior? Should it skip weekends? Holidays?

For a straight day calc, just mins the values:

Code:
=A2-B2

'assumes "due on site" is in A2
'assumes material lead time (in days) is in B2
For skipping weekends and holidays we can make use of some of the many date functions in Excel, like WORKDAY() or NETWORKDAYS(). If you specify what you start with, and the expected results, we can write the function(s) for you.
 

3 more replies
Relevance 44.69%

OK, this might sound mad but here go's.We have an ever expanding series of progress sheets that track delivery on numerous independent projects. They are, for internal reasons, all seperate workbooks and need to remain so. I have sussed a way to auto send an email from each workbook based on any overdue deliveries. That works fine as far as it go's. My problem is that the workbook has to be opened to run the code. The guys who use these will only open what ever wbook they are currently working on each day, which is no good as I want a daily check on overdue items across the spectrum. What I would like, is some sort of stand alone selection sheet with project list and a means (Maybe checkboxes) where we can specify current live projects and deselect dead/complete ones and somehow automatically open and close the live workbooks just to run the check. Is this just wishful thinking, or does it sound feasible?Hope that makes some sense.Cheers

More replies
Relevance 44.69%

When a document in Excel is 'Auto-Saved' is it stored on your own PC or does it go to a central server somewhere? Friend has a lot of sensitive data each month and is worried that auto-save sends it away from her PC to a central server where it may be 'hacked' by some unscrupulous person. Any help gratefully received.

Answer:Auto Save in Excel Spreadsheets

"...worried that auto-save sends it away from her PC to a central server where it may be 'hacked' by some unscrupulous person."
Tell your friend to stop worrying - the file is auto-saved locally, there's no 'central server' involved.

2 more replies
Relevance 44.69%

Hi, I am looking for help to create an Excel spreadsheet (excel 2007) which will be updated automatically whenever my colleagues save files to my team's sharedrive.

The Excel spreadsheet shall have columns with: name of the file, type of file(eg: pdf, word, excel, powerpoint), name of the sub folders which these files are saved in, date which the file is saved.

Many thanks =)
 

Answer:Excel: auto update on sharedrive

11 more replies
Relevance 44.69%

I need my cost spreadsheet to auto calculate annual runrate. I enter each months costs and i want the sheet to calculate the end of year run rate. How do I instruct the sheet to recognise what month is current so that it can divide by the appropriate months and then multiply by 12?

Answer:auto calculate run rate in excel

Without knowing how your sheet is set up, to get the current month try:=MONTH(TODAY())MIKEhttp://www.skeptic.com/

2 more replies
Relevance 44.69%

For some reason, the workbook I am using will not automatically adjust the row heights when I double click on the row divider. Any ideas on why this is happening or how to solve it?
 

Answer:Rows Won't Auto Resize in Excel

7 more replies
Relevance 44.69%

Hello,

I have read through a lot of posts and have not come across one that actually fits my issue. I am trying to come up with a macro or a formula that will do the following:

Date
27-Oct-08
28-Oct-08
29-Oct-08
30-Oct-08
31-Oct-08
3-Nov-08
4-Nov-08
5-Nov-08
6-Nov-08
7-Nov-08
10-Nov-08
The date (the word Date is A1) is in colume A and the row is what is changing (ie A2 (27-Oct-08), A3 (28-Oct-08), A4 (29-Oct-08), etc) I don't want the weekends if possible. I have tried a formula but something is wrong with it "=DATE(YEAR(A2),MONTH(A2),DAY(A2)) - IF(AND(MONTH(A2)=2, DAY(A2)=29),1,0)" It makes every day (every row the same value, doesn't increament) The IF statement is suppose to check for leap year. The =Today() changes all the days to be the same, which I don't want. Can anyone modify this so that it works or auto puts the date in the next row?
Each row gets a new date, I don't want to have to hand type in the date everydat if I don't have to.

Thanks in advance.
 

Answer:Solved: Excel auto date

Hi there, welcome to the board!

If you have "Date" in A1, and your start date entered manually into A2, you can put this in A3 and copy down...
Code:
=IF(WEEKDAY(A2)=6,A2+2,IF(WEEKDAY(A2)=7,A2+1,A2))+1
HTH
 

2 more replies
Relevance 44.69%

Hi

I have a excel document is sorted by either Urgent,High,Medium depending on how long a account has been disconnected.
This changes daily as its driven by a date formula.

Is there any way i can autosort this so that when i open the document the accounts are sorted by Urgent,High or Medium?

Thanks
 

Answer:excel 2007 - auto sort

shabbir1309, welcome to the forum.

If you could, please attach a sample file. You can replace sensitive data with dummy data.
 

2 more replies
Relevance 44.69%

How do you turn off auto correct in one cell of Excel. I'm trying to type HDA and it keeps changing it to HAD.

Answer:Auto Correct question with Excel

Autocorrect is all or nothing. However, you can remove auto correction words from the office dictionary. To do that for excel 2007 and newer, click the windows icon/file button in the top left corner and click on options. Once in the options menu, click on 'Proofing' and click on the 'AutoCorrect Options' button.In the window that pops up on the 'AutoCorrect' tab, scroll through the list until you find 'hda-had' and delete it from the list.Your other option is to just turn off the 'Replace text as you type' feature by un-selecting its check box.Law of Logical Argument: Anything is possible if you don't know what you're talking about.

4 more replies
Relevance 44.69%

I have a spreadsheat that I periodically update, and in the lower left hand corner I manually type the date that the information is updated. Is there a macro or such that will automatically update the date when the spreadhseat is opened?
 

Answer:Auto update the date in Excel

Do you want the macro to change the date when the workbook is opened or everytime it is saved?

There are two events you can choose from to place the macro. Both events are in the workbook Module. With the Workbook open, press ALT + F11 to bring up the Visual Basic editor. On the left side of the editor window you will see your project explorer. Find the item called ThisWorkbook and double click it. This will bring up a blank workbook module. Just copy and paste either of the two code modules below. Just change the destination location of the date which I have made "A33" in the code. The first code is for the Before_Save event and the second is for the Workbook_Open event.
Code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("A33").value = Date
End Sub
or

Code:

Private Sub Workbook_Open()
Range("A33").value = Date

End Sub

Rollin
 

2 more replies
Relevance 44.69%

Okay, I've gone through the fora here and tried to modify some of the macros to do what I want, but I've crapped out. I'm not a coder, and this is a bit deep in Excel for me.

What I'm looking for is a macro that will sort 30 groupings of 5 numbers in descending order (within each group, not with all of them).

I've tried recording a macro too, and that was pretty much a disaster.

Each of these clusters of five gets sorted, then the middle three are averaged in an adjacent cell. The averaging I was able to take care of easily enough, but I would like the sorting to be automatic, just to save keystrokes/mouse clicks.

Here are the clusters that I want to sort in descending order:

A9:A13
A15:A19
A20:A25
A27:A31
A33:A37
A39:A43
F9:F13
F15:F19
F20:F25
F27:F31
F33:F37
F39:F43
K9:K13
K15:K19
K20:K25
K27:K31
K33:K37
K39:K43
P913
P1519
P2025
P2731
P3337
P3943
U9:U13
U15:U19
U20:U25
U27:U31
U33:U37
U39:U43

So for instance, A9 through A13 are sorted from high to low and A10, A11 and A12 are averaged in B10. There's probably a more elegant way of doing the averaging, but I'm just using the SUM average.

There are 4 tabs to the workbook, all just like the above. I assume that I can use the macro... if I ever figure it out... on each of the 4 tabs.

I'd appreciate any help anyone can provide... I'd like to learn to do it myself, but even with all the reading I've done, it stymies me every time.

Thanks in advance for any help,
Oblivious... Read more

Answer:Another Excel Auto Sort Plea

7 more replies