Computer Support Forum

Excel Formula If/And or If/Then Reminder Question

Question: Excel Formula If/And or If/Then Reminder Question

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 100%
Preferred Solution: Excel Formula If/And or If/Then Reminder Question

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 67.24%

I have one cell (I22) containing a number that I manually enter. I want this total to be broken down and listed in 3 other cells, putting 50% of I22 into one cell, 25% into another cell and 25% into the third cell. I want all 3 of these cells to equal I22, but with rounding they are off 1 cent.

For each cell I used a formula as follows: =I22*0.50
=I22*0.25
=I22*0.25

In options, under calculation, I have checked the box "Precision as Displayed" to avoid rounding errors. What else must I do to ensure the 3 cells won't be off due to rounding?
 

Answer:Excel formula question

Crude, but effective....

Calculate the 3rd field as 100 less the sum of the other 2.
 

2 more replies
Relevance 67.24%

In my spreadsheet, I have Col. A that has several Division Names. Some of the names are duplicated. Col. B has the part number/name that the division carries. Col. C has the price for that part, in that division.

I know how to do a simple VLOOKUP, but how do I say, If Div=ABC and Name=123, show the price in Col. C?

I thought it would be easy, but am obviously doing something wrong.

Thanks!
 

Answer:Excel Formula Question

9 more replies
Relevance 67.24%

This should be a pretty easy issue for anyone that know how to write Excel formulas.

I am trying to insert the following two formulas into one cell and I don't know how to combine them together.
=IF(I29>50000,D30*0.1)
=IF(I29>80000,D30*0.2)

The formula is to add 10% bonus if the volume is 50,000 to 80,000, and 20% above that amount. But when I combine them, I'm making an error and it seems only 1/2 the formula works.

Thanks for the help.
 

Answer:Excel formula question

Possibly you're not covering what should happen if I29 is less than 50000. Try

=IF(I29<50000,0,IF(I29<80000,D30*0.1,D30*0.2))

HTH,
Andy
 

1 more replies
Relevance 67.24%

Hello:

I am trying to figure a way to do the following.
In the first row i want the months
in the second row i want numbers from 100-184
Now say in July the contents for #100 is 0
Now say in Aug the contents for #100 is 11
Now say in Sept the contents for #100 is 14
Now say in Oct the contents for #100 is 52

What i want the sheet to do is to take the difference in july and august and if the difference is less than 5 flag/mark it and if the difference is greater than 40 flag/mark it. then the next month when i enter the data for Sept it will take the difference in Aug and Sept and use the same rules to flag it less than 5 or greater than 40 for usage

Any help would be great
 

Answer:Excel Formula Question

14 more replies
Relevance 67.24%

This is a little hard to explain but if I could do this it would save a great deal of time. I have a function that requires a large series of iterative calculations.

Anyway here is what I need to do (at least one part, there are 10 different type of calculations), I have a column of data that needs to have a LARGE number of different calculations done on it. Specifically, I need each value brought to a specific exponential which varies with each iteration, what I would like to do is sum(b28^1.6:b58^1.6) In other words I would like to have each value brought up to by the exponent 1.6 and summed. (the exponent will vary for the 50 or so times I have to do it) I have been doing a column each time to calculate and then sum but this is time consuming not to mention hard to follow.

I would like it if I could use a statement to do a calculation on each cell individually and then sum them without needing another column each time. (if this was possible I would be done now)

Any suggestions
 

Answer:Excel question, how do I sum a formula?

8 more replies
Relevance 67.24%

Hello,

I have a roster of students, about 8000 rows of information.

Column A is their campus name - (for example, Smith elementary)
Column B is their grade - 0, 1, 2, 3, 4, 5, 6, 7
Column C is the type of classroom they are in (FAC, LSC, TLC)

I want to gather the number of students who attend Smith Elementary, are in the FAC classroom AND who are in grades 0, 1, 2, 3, 4, 5, 6.

I also want to gather the number of students who attend Smith elementary, are in the LSC classroom and who are in grades 0, 1, 2, 3, 4, 5, 6.

I have tried using countifs but it adds everything together. I tried using sumproduct but got an error. I then explored count, lookup, and vlookup but keep getting errors.

Any suggestions?

Thanks!
 

More replies
Relevance 67.24%

I'm trying to make sense of a spreadsheet I have been given and need to do the following:Every day we send out the same pieces of information that are copied from the previous day and then the formulas automatically update, or at least they did before I started working here.The formula I'm trying to automate looks like this:=C$3-$A1210 (Obviously these change)C$3 is the current amount of days until the event and $A1210 is the current date...so it basically deducts a day each time according to the date in column c$3.I can't figure out how to automate this so that when I copy all the data from the previous day it will update the $A1210 cell to the next days and insert lets say $A1222 which would be the row in which the date is set for the next day and so forth.I hope that makes sense? Any pointers would be appreciated

Answer:Excel Formula Question

VBA is probably what your looking for if you don't already have VBA in use. If it was working until you got there my thoughts on this are that someone was manually entering the data before you got there maybe, as for it kind of makes no sense for something to stop like this just because you started there unless you broke it by accident http://www.mrexcel.com/forum/excel-questions/585028-insert-data-into-next-blank-row-visual-basic-applications.html

3 more replies
Relevance 67.24%

Esteemed listers:I?m attempting to set a cell?s value as follows, I have columns b and c either one (and only one) will contain values. Once I determine which column has data, I need to interrogate it and set values as appropriate. Pseudo code:If b13 not equal spaces and b13 <= 10000 then set value to 32 else if b13 not equal spaces and b13 > 10000 then set value to 64else c13 not equal spaces and c13 <= 10000 then set value to 32 else if c13 not equal spaces and c13 > 10000 then set value to 64 Tried various iterations such as (to no avail):="SEGSIZE "&IF(AND((Request!B13)<>" ",(Request!B13)<=10000),32,64),IF(AND((Request!C13)<>" ",(Request!C13)<=10000),32,64)Tku,Jeff A

Answer:excel formula question

By "not equal spaces", do you mean the cell is not empty?

1 more replies
Relevance 67.24%

I have a work book that dispatches deliveries to stores. We normally re-configure at least 2 times a year. We have serviced as many as 106 stores and as few as 42 stores.

I have found an easy way to add new stores to the workbook, but, I need a formula that when I type in a store number (in the Remap Delete Sheet) it matches the store # in the store information sheet, moves it to row 200 where it can be deleted without affecting the formatting of the rest of the work book.
I would like to be able to due this operation using a Macro.

Any suggestions?
DLG
 

More replies
Relevance 67.24%

Hi,

I was wondering if someone could help me.. I am tracking my running on an excel spreadsheet in distance covered (km) and time completed (hours/min/sec) . Is there any formula that can calculate the average distance covered per minute and one that could calculate the average speed in km over the duration of the run??
Thanks for your help

Dayne
 

Answer:Excel Formula Question

Someone else may have a more elegant solution, but here is a spreadsheet with formulae to get your results. Note that the time is entered in 3 cells (hrs, min., and sec.).

reply with your e-mail address for the file. Looks like I can't send an .xls from the forum.


 

1 more replies
Relevance 67.24%

I'm trying to set up a spreadsheet in Excel, but I'm having a little trouble setting up the formula. It's been too many years since I took excel or math classes.

What I'm trying to do is add together two cells, and then subtract that value from another cell. Can anybody tell me what formula I can use?
 

Answer:Excel formula question

Something like this:

=sum D5-(A1+B1)

Where D5 is the "other" cell you refer to.
 

3 more replies
Relevance 67.24%

Ok i am trying to do a little bit of the above and beyond my normal job duties thing and am running into a wall with trying to write this equation so i was hoping someone here could point me in the right direction. I have 3 collums. Collum C has formulas in it so that if A and B in the same row both have an X in the cell than cell C in that row will show an X as well, otherwise it shows a O. What i am trying to write now is a statemane that will allow me to show the realtime percentage of cells in collum C that have an X.

More replies
Relevance 67.24%

Hi i am trying to create a formula on which it will look up a specific date in a workbook and then add the values under a range of cells in different worksheets
 

Answer:Excel Formula Question

First, welcome to the forum!
A bit more information, please. Where is the date located (sheet name and actual location) and then the ranges - sheet names and locations again.
Or upload a file of your workbook - make sure the data is not confidential.
 

2 more replies
Relevance 67.24%

Let me first explain the spreadsheet i'm making so you'll understand my question

XXXXOOOOXOOOOX (Consider X=Off, O=On) This is just an example row of information

I need to calculate consecutive off time. So pretty much how long the light has been off. Looking at the example above, the answer is 4 since the first four listed are X's. I don't care about the other X's in the row, since it's not consecutive.

How would I write that into a formula, I've been racking my brain for a week...
 

Answer:Excel formula question

10 more replies
Relevance 67.24%

I have a series of sheets, which follow on from one another. In the 1st sheet N39=N37-N38 and N40=N38-N37. Obviously 1 of these will always be positive and the other negative unless both = 0.The question is, how do I make Sheet2 E9=Sheet1 N39 if N39 is positive but otherwise 0 and sheet 2 E10 = sheet 1 N40 if N40 is positive but otherwise 0.Thanks for any help - I've been playing with this for hours and am either missing something very simple or its way over my head (probably the latter).

Answer:Excel formula question

make Sheet2 E9=IF(sheet1!n39>0,sheet1!n39,0)andSheet2 E10=IF(sheet1!n40>0,sheet1!n40,0)

8 more replies
Relevance 67.24%

Can someone tell me what certain parts of this formula is doing please.=SUM(B8+B9)-G12-(F19*-1)-(H32*-1)-H19what is the *-1 doing in the above formula?Many thanks,

Answer:Question re excel formula

* means multiply and in the formula i would think it is multiplying h32 by -1. so if you substitute the formula with the figure 10 it effectively becomes this:=SUM(10+10)-10-(10*-1)-(10*-1)-10;=SUM (20)-10-(-10)-(-10)-10; note two minus's= a +thereforeit becomes;=SUM 20-10+10+10-10;=Sum 20hope this helps

8 more replies
Relevance 67.24%

A1 has an EMBED Check Box. If checked (TRUE) then B1 shows the current date and time "NOW()" if unchecked (FALSE) B1 shows blank.

Whats the formula for A1 and B1?

I've got it working but my problem is I have, for example 15 rows. A1:A15 all have check boxes and B1:B15 have the time. But every time I uncheck a check box and recheck it, Excel puts the current date and time in B1:B15.

I don't want it to recalculate B1:B15 I just want it to calculate the next box in the row. A1 calcs time and date for B1. A2 calcs time for B2.... etc.
 

More replies
Relevance 67.24%

Hi, I have two columns in my worksheet one with Y's and N's to indicate yes's and no's and the other with corresponding dates. I need a formula that will look in to the the Y/N column and extract the earliest date associated with Y. I thought combining a sumproduct and an if statement in some way might solve the issue but that hasn't worked. Am I going about this all wrong or do I need to do something different?Thanks!

Answer:Excel formula question

Provided your data looks like this:
A B
1) 10/3/2011 y
2) 10/4/2011 n
3) 10/5/2011 y
4) 10/2/2011 n
5) 10/7/2011 y
6) 10/8/2011 n

Then in cell C1 enter the formula:=VLOOKUP(MIN(A1:A6),A1:B6,2,FALSE)EDITAfter re-reading your post, not sure this is what you want.MIKEhttp://www.skeptic.com/

12 more replies
Relevance 67.24%

I am subtracting two numbers and having the answer put into a seperate cell. I then need to take that number and depending on the answer place an X in the appropriate age column. I did this so far and it is not working but I do know how to fix it. f2-e2 in column h2.In column i, I wrote =IF(h2=1,"X") It is the if statement that I am having the error show what am I doing wrong.

Answer:Excel IF Formula Question

There is nothing wrong wth your formula that would produce an error.What error are you getting?

5 more replies
Relevance 67.24%

Is there a formula that will find the value within the last populated cell in a row or column?

Answer:Excel formula question

Last value in Row B=LOOKUP(9.99999999999999E+307,2:2)

8 more replies
Relevance 67.24%

I am working with an Excel spread sheet. It is a list of item numbers for specific products that need to be photographed. Some of the items are retakes (products which we have already photogrphed but need to be redone somewhat differently). However many of the items on the list that are marked as retakes are realy items that we have never photogrphed before. I have added two additional columns. One labeled "photo" where we enter the date the item was photographed and one labeled "retake" where we enter "y" if it is a ligitmate retake. What I want to be able to do is count the number of "y's" for any given date.

On sheet 2 I have columns labeld Date, Photo, Retake, and Percent

All but Retake are working as expected.

I used the following formula in the Retake column:

{=SUM((Photo=A2)*(Retake="y"))} Where A2 contains the date.

The result returned is #N/A . What I want is the number of "retakes" on the date in cell A2.

It seems to me that the equation should return that.

Any suggestions/corrections???

Carl
 

Answer:excel formula question

8 more replies
Relevance 67.24%

Hello:

I have a spread sheet that calculates the leave taken on a daily basis. However the leave taken must be shown as .1, .2, etc. going up to 1.0 with each representing 6 minutes. (ex. 6-11 minutes taken would be shown as .1; 12-17 minutes shown as .2; 24-29 minutes taken shown as .4 etc)

There are 3 places for each day of the week where formulas would appear.

Cell H12 takes the hours worked in the morning the formula is: =IF((OR(G12="",G11="")),0,IF((G12<G11),((G12-G11)*24)+24,(G12-G11)*24))

Cell H15 takes hours worked for the evening, the formula is:
=IF((OR(I15="",I14="")),0,IF((I15<I14),((I15-I14)*24)+24,(I15-I14)*24))

Cell G16 takes those formulas and gives the total leave taken, its formula is:
=IF((OR(G15="",G14="")),0,IF((G15<G14),((G15-G14)*24)+24,(G15-G14)*24))-8

My problem is this:
With these formulas my leave taken is being shown in this manner:
3-8 minutes = .1; 9-14 minutes = .2
instead of the manner i described in the beginning of this post.
What do I need to change in one or more of these formulas to get the leave taken to show up in the format I want?

Thanks. I hope I described it clear, or as clear as possible.
 

Answer:Excel Formula Question

16 more replies
Relevance 67.24%

Okay first off with the simple question:

I know there is conditional formatting with excel, but it only lets me to set 3 conditions. Is there anyway to add more?

Mainly something like this
<=1 ------- Red
between 1-4 -----------Orange
between 3-6 ------------Yellow
= 6 -------------YellowGreen
IF(SUM(B1:F1)=36, Green)

Look at the follow question and click the link to a good idea what I want.

Advanced:
I am looking for tips, hints, formulas, comments, suggestions for the following.
hostima.net/paroxsitic/excel.html
It would be insanely awesome if someone could actually get a start on my ideas and post a link to a working copy, I might even spit out some money for it.

Thanks alot.
 

Answer:Excel - Formula question

First, the conditional formatting which you mentioned lets you set 3 conditions, which actually gives you 4 possibilities - the default and the 3 formats you set. Unfortunately, you want 5, which is totally beyond the realm of conditional formatting. Now, you can still do this, but you'll have to use VBA and, depending on how big the area of cells you want to format is, it could impact the speed of the sheet refresh. So I took a look at your link so I could get a better understanding of your requirements.

I think this is feasible, but I've got some questions about your formula. You said, "Cracked is worth 1 point. Chipped worth Cracked x 1.5, Flawed worth Chipped x 1.5 ..etc." Now, if I follow the description exactly, the formula becomes
B5+(C5*B5*1.5)+(D5*C5*B5*1.5)+(E5*D5*C5*B5*1.5)+(F5*E5*D5*C5*B5*1.5)
(parenthesis are superflous, but they make it easier to see the various factors)

The formula you gave

C5+1*1+D5*(C5+1*1.5)+E5*(D5*1.5)+F5*(E5*1.5)+G5*(F5*1.5)-1

does not reflect the description. First of all, the formula seems to be one column off from your example. But if I move everything to the left one column, it gives the same results as in the example. If I understand your intent, it should be

B5+(C5*B5*1.5)+(D5*E5*1.5)+(E5*D5*1.5)+(F5*E5*1.5)

What I had originally interpreted from your description was

B5+(C5*1.5)+(D5*1.5*1.5)+(E5*1.5*1.5*1.5)+(F5*1.5*1.5*1.5*1.5)

Interestingly, these formulas give quite a variation/

Formula 1 Yours Formula... Read more

1 more replies
Relevance 67.24%

Hello,

I am working on my taxes, and have downloaded pertinent transactions from my bank into an excel document. I am looking for a way to gather a total for each of my categories. For example, I have multiple dentist entries and a corresponding amount spent for each visit.

A1 = Dollar amount
A2 - Category (Dentist for this example, though there are several other)

I want a formula that will provide a sum of all my transactions for the given category. I thought it would be an "if then" formula but couldn't make it work. Then I thought it would be a "sum product" formula but couldn't figure the correct wording.

Any advice?
 

Answer:Excel Formula Question

6 more replies
Relevance 67.24%

If I have a number of contiguous cells in one column(eg H30 to H36), and each one has a formula that returns either the word pass, or the word fail, and I want one other cell to return the word PASS if all the other cells contain pass or fail if one or more of the other cells contain the word fail, I can do it by using something like =if(or(h30 <> pass, h31 <> pass, h32 <> pass, h33<>pass, h34<>pass, h35<>pass, h36<> pass, "FAIL", "PASS")
(the syntax might not be bang on here, as I am using memory from work)

How can I condense all of the cells into something like (h30:h36) and still have it work.

This is not a big deal, as it works the way it is, but it bugs me that I can't get it, using AND or OR
 

Answer:Excel formula question

=AND(H30:H36) will work, as excel treats TRUE and FALSE as valid logical values
 

8 more replies
Relevance 66.42%

so I have a list of questions in my excel worksheet. Column A has the questions and Column B is where i will type my answers.

Also, questions are typed in english for the odd number rows, and the even number rows have the exact same question in a different language.

I have 3 macro buttons at the top of my excel sheet.
one button will run an autofilter and show only the questions in english and hide the question that is in the otherlanguage.

another button will run the autofilter to display everything.

the 3rd button is a 'clear all' button where it will clear all the answers so I can re-use the template.

there is also a 4th button that will display the current date and time.

Everything is done except for one thing:

throughout my excel sheet, I have some IF formulas in column B of various rows where it will pre-fill answers to other rows if needed.

for example, If the answer to the question on the 4th row is 'no,' then the answer to the 5th row will be automatically be filled as 'N/A.' if the answer is yes or something else, it'll just be blank.
That way, I can just skip to question 6 and not worry about question 5.
IF(B4='no,' 'N/A', ' ',)

the problem is when I press the 'clear all' button. it automatically clears everything, including the formula. Is there a way that I can protect the formula, but not the data that is in the cell?

I tried to play with the protect function a bit, but when I... Read more

Answer:question about excel formula protection.

This should select all the non-formula cells in column B:

Range("B1", Range("B" & Rows.Count).End(xlUp)).SpecialCells(xlCellTypeConstants, 23).Select

If that works OK, modify it slightly (note -- save your work first):

Range("B1", Range("B" & Rows.Count).End(xlUp)).SpecialCells(xlCellTypeConstants, 23).Clear
 

1 more replies
Relevance 66.42%

Hello everybody. I have 2 questions, both pertaining to each other.

1. Is there an easy way to combine the prefix, first name, middle name, last name, and suffix columns of a .csv file into a single column so that my Outlook '07 .csv file will be compatible with Gmail's web based contact book. Everything goes in fine except for contacts with only a first name. If there is no last name, no name goes in at all. Any suggestions.

2. If the answer to #1 is no, then is there any easier way to make this Concatenate formula relative to each row?

=A3& " " & B3& " " & C3& " " &D3 for the 3rd row,
=A4& " " & B4& " " & C4& " " &D4 for the 4th row.

As of now, I have to paste the formula, and manually change the numbers to correspond with the row.

Any suggestions. Thank you in advance for looking.
 

Answer:Solved: Excel formula question

15 more replies
Relevance 66.42%

Any Excel guru's out there?I have been asked by a colleague if there is an Excel formula that can automatically change a number of seconds to a time.ie cell A1 has the number 145 can a formula be entered into cell B1 that converts this to 0:02:25 meaning 0 hrs 2 mins 25 seconds.Thanks

Answer:Excel Time Formula Question

To transform minutes in hours and minutes (125 becoming 2:05), use this simple formula (the format of the destination cell must be hh:mm): =A1/1440 click here more useful info here

6 more replies
Relevance 66.42%

Hi,

I am working on an excel document and am having difficulty figuring out how to do something. Here is what I have:

1. 80 rows of student names.
2. Multiple columns of data for each student.
3. One of the columns is their race.
4. Another column has a "yes" or "no" response.

I want to get the count of students for each race AND who have a "yes" response.

I have played around with the Countif function and can get a count of each of the races but cannot figure out how to do both.

Thanks in advance!
 

Answer:Solved: Excel Formula Question

Hi misterjw. welcome to TSG.

You can do it with a sumproduct formula:

=SUMPRODUCT((A1:A80="race")*(B1:B80="yes"))

Of course you'll need to replace your ranges and the "race" to fit your spreadsheet. Hope that helps.
 

2 more replies
Relevance 66.42%

This should be pretty simple in my opinion but can't seem to figure out why it's erroring out. I'm trying to use an offset(match()) function to match data from two tables.
Each table has a column of dates, and a column of data on different tabs.
The dates on table1 are monthly from 3/1/09 to 3/1/12
The dates on table2 are monthly from 3/25/09 to 3/25/12
I don't care about the day of each month, just that the months themselves match so I can look up the values between the tables.

See attached as an example.

What is the best way to look these up? I have my two attempts in the first two rows of the first tab.
 

Answer:Solved: Excel Formula Question

=INDEX(Sheet2!D,MATCH(DATE(YEAR(C5),MONTH(C5),25),Sheet2!C:C,0))

or:

=INDEX(Sheet2!D,MATCH(C5,Sheet2!C:C,-1))
 

3 more replies
Relevance 66.42%

I have a quick question on a formula for excel. How do I create a formula for a filed that I need to calculate accrued interest that is compounded monthly?

For example:

Loan balance $5000
Accrued 16 months
Interest Rate is 6%

The interest accrued is $406.79
This is the field I cannot create a formula for.

Help a rookie out. Please
 

Answer:Excel Formula-easy question

6 more replies
Relevance 66.42%

Hello all, I have a huge excel table with a lot of data. There are 4 columns within the table that I need to change. The best way I can explain it is relating it to sports stats.

Column 1= Wins
Column 2= Losses
Column 3= Total of Wins and Losses
Column 4= Win Percentage

I know the formula to get the win percentage For example ( =(AD3/AF3)*100 )

My question is how can I copy and paste this formula in all the 200+ rows so it gives me the correct number for each row. In the above example I would want the win percentage for row 3 but when I paste the formula into the row 4 cell I would want the row 4 win percentage.

I hope that makes sense. Thanks much for your help.
 

Answer:Excel Formula Question (Getting a percentage)

9 more replies
Relevance 66.42%

What is the SINGLE formula to the following in Ms Excel 03'? I need to find the greatest value of A1, C1, and D1. Once found you need to take B1 and divide into the results. The (obviously A1 is the greater value, and B1/A1) answer I need to show in E1 is 97.88%. Below is best example I could make of how it might look in spreadsheet.

A B C D E ................
1 56.8 55.6 54.2 52.8
2
3
4

The best formula I could come up with was =IF(A1>C1,"A1",IF(A1>D1,"A1",IF
(C1>A1,"C1",IF(C1>D1,"C1",IF(D1>A1,"D1",IF(D1>C1,"D1")))))) and the answer I get in E1 is A1

Thanking anyone in advance
 

Answer:Solved: Ms Excel Formula question

6 more replies
Relevance 66.42%

Hi,

This is a complicated feat for me. Can someone help me figure out a formula to consider the criteria in the attached spread sheet? Details in attached spread sheet.

Thanks,
Pulling my hair out...
 

Answer:Solved: excel formula question

14 more replies
Relevance 66.42%

OK... I've done researched best I could.. and cannot seem to find how to pull data from my worksheet using a conditional formula.  I have several columns of data in which one of them contains time in the format HH:MM:SS.  These times are sorted by end user extension and I wish to add them up for each user.  Does anyone have any ideas?  Here is what I was trying: =IF(VLOOKUP(5374,Sheet1!D:F,1,3),SUM(Sheet1!F:F),"No Time")... and well.. that doesn't work.   :-/Any suggestions would be much appreciated.Thanks.AV.

Answer:Excel 2003 Formula Question...

What about taking different approach?  I created a simple data set for testing:name      timedave      11:23:33dave      10:12:17dale      9:57:00dale      11:09:22Dean      10:45:22Dean      9:37:45Then, I used Data, Subtotals to get:name      timedave      11:23:33dave      10:12:17dave Total      21:35:50dale      9:57:00dale      11:09:22dale Total      21:06:22Dean      10:45:22Dean      9:37:45Dean Total      20:23:07Grand Total      15:05:19

3 more replies
Relevance 66.42%

Simple question, I hope:

I go to a cell and type in =1+2, hit Enter and I get 3

I go to another cell in a different column and I type in =1+2 and I get =1+2

I've checked the formatting - its "number". I've retried this many times and am stumped. I'm not putting an apostrophe in front of the =1+2 either.

Any ideas as to what's causing this, anyone? Thanks in advance
 

Answer:Excel Question: Formatting a formula

13 more replies
Relevance 66.42%

Need help figuring out a formula.

If I have a number in a cell. Lets say it is 42.28

and I want to use a formula to automatically calculate the first number divisible by 4 that is less than 42. 28 (so the formula should calculate 40)

and I want to use a formula in another cell to calculate the first number divisible by 4 that is greater than 42.28 (so the formula should calculate 44)

is this possible?

thanks.
 

Answer:Excel 2003, if formula question

11 more replies
Relevance 66.42%

how do i create a formula in excel that would take the date 6/7/2006, which is in A57, and then add 7 days to A58 to get 6/14/2006 and so on. i want the A column to continuously add 7 days to each row. how can i do that? i am using excel 2007. i also have excel 2003
 

Answer:Solved: Excel Formula Question

14 more replies
Relevance 65.6%

I need to make a fill in the blank formula. the problem is that the text i need surrounding it is used by excel for functions. it is going to be used for html.

this is what it should look like look like: this is ofcoarse referncing to an adjacent cell. But i need ALL of the text to show, including the punctuation marks.
<option value="A1">A1

so in short if A1 has text that says "abc" in it, then i need it to look like
<option value="abc">abc

can someone pls send me a formula that will do that.
 

Answer:Microsoft Excel 2007 Formula question

So, this is really for a web page, not an actual Excel application? Are you trying to create a form for a web page where the visitor chooses from given answers to certain questions? If so, have you tried just creating a form in HTML?

This discussion might be helpful: http://forums.majorgeeks.com/showthread.php?t=199681
 

2 more replies
Relevance 65.6%

Hi from a fairly new user of Excel. I'm working on this spread sheet and was wondering how to change one variable while keeping other variables from not changing.
The formula is as follows:
='[02-DailyServiceMetrics FEB-2012.xlsx]DAY 11'!E31
I would like to have the DAY 11 change to consecutive order while keeping the E31 the same.
How do I do this.
Thanks.......
 

Answer:Solved: Excel basic formula question

6 more replies
Relevance 64.78%

I'll try to keep this short. I am trying to have a column in one portion of of my Excel worksheet pull information from the same column but in another section of the worksheet. Basically, I'm looking to pull the value from every 16th row of the lower section of my worksheet. Specifically... In cells H3, H4, H5....etc... I'm trying to have cell H3 equal the contents of H200, cell H4 to equal contents of H216, cell H5 to equal contents of H216...etc. If I type in cell H3 "=H200" and in cell H4 "=H216" and try to do a fill down, or some kind of fill series etc... It doesn't fill the desired way... Does anyone know how I could get the desired fill down that I am looking for. I've tried all I can think of. (My fill down will be 200 cells in the column... so manually entering isn't really an option...especially since I will want to do the same in about 5 columns).

Thanks for any help!

-RChampiDC
 

Answer:Solved: Microsoft Excel Question (Filling Down with a Formula)

Welcome to the forum RChampiDC.

When you do the fill down with formula, Excel will move one cell space down.

What can be done to achieve what you ask is to use a helper column where you can fill down the row numbers down by increments of 16. Say you do this in J3, start at 200 then 216 and fill these down. So you end up with
200 216 232 248 264 280 296 ...etc

In Cell H3 down you can use the formula

=INDIRECT("H"&J3)
 

2 more replies
Relevance 64.37%

Awesome! Thanks for your help......here is the continuation, I hope I can explain this:

2 situations

A3=3000
B3=5000
THEN IN CELL C3=3000 AND D3=0

BUT,

A3=6000
B3=5000
THEN I WANT C3=0 WHICH WILL HAVE D3=1000

IN OTHER WORDS, TOTAL LOSS OF VEHICLE EQUALS 6000, TOTAL OF LIENS EQUAL 5000, WHICH WOULD NOW HAVE ALL PAYMENTS GO TO THE CUSTOMER IN D3=1000 AND NONE TO THE LIEN HOLDER C3

AGAIN, THANKS FOR YOUR HELP AND I PROMISE THIS IS ALL I NEED!
 

Answer:Solved: Continued Negative number formula in Excel (Last Question)

This was addressed in this thread and thus can be closed as dup or marked complete.
 

1 more replies
Relevance 61.09%

For some reason I cannot get Excel 2000 to display the results of a formula. Only the formula text displays. I've gone to Tools-Options-View-Windows Options and checked and unchecked the Formulas checkbox. It doesn't make any difference.

Help!

Thanks,

Thomas
 

Answer:Excel 2000 Formula Text Displays instead of Formula Results

Format the cell as a number, it prolly is fmt'd as text
 

3 more replies
Relevance 60.27%

Hi ~

I'm working on a financial formula, trying to calculate a growth rate for a row of cells. The problem is that not all rows have complete data sets, so the formula picks up blank cells and returns a #DIV/0! error.

The existing formula works fine for those rows that have non-zero entries in all cells, and I *can* manually adjust the formula for the starting / ending cells in each row--but what a pain(!). As this spreadsheet grows larger, or the data sets change over time, it means I have to constantly keep adjusting it for every row of data involved, which is extremely time-consuming.

Here's an short example of what I might have in any given row:

A1 (blank), B1(blank), C1(blank), D1(.10), E1(.25), F1(.72), G1(1.0), H1(.80), I1(.60), J1(.75)--then in K1 is the growth formula, e.g. =((J1/A1)^(1/10)-1).

Is there ANY way to create a formula that will dynamically adjust for the blank cells that might exist across a row of data and let the formula do the calculation?

I'm new to advanced Excel topics, but any ideas would be MOST appreciated(!).

Thanks -

CP
 

Answer:Excel Formula / How Can I Ignore Blank Cells In Row Formula?

14 more replies
Relevance 59.04%

Hi, I need to do the following:

Search array
1 a 12 asdas
2 b 121 agrsfsa
3 c 3 qwgds
4 b 131 erwer
5 e 4123 q3eqt

need to return something like this
lookup value b

answer should look like this

2 b 121 agrsfsa
4 b 131 erwer

index, match can give me one row, however what could return multiple values

Thanks in advance for your help.
Cheers
 

Answer:Excel: Is there any formula that would do Autofilter's functionality as a formula

8 more replies
Relevance 59.04%

If it's possible to do this, what is the formula syntax for an if/then formula in one sheet that refers to the cell value in another sheet in the same workbook?
For example in Sheet 2, the formula would be something like, if Cell A10 in Sheet 1 is greater than 0, then the value of Cell B20 in Sheet 2 would by "Yes" but it would be "No" if the valuein Cell A10 in Sheet 1 was less than 0.
 

Answer:Excel formula using formula between sheets in workbook

6 more replies
Relevance 56.99%

I have created a formula in Excel that works fine, but when I put it into a MS Word table, it doesn't seem to work. The formula adds up a column of prices when the resulting column has a specific word in.

The formula is:
=SUMIF(E:E, "Yes", D:D)

Example:


Is this possible to do? If so can anyone help converting this so it will work in MS Word.

Thanks, Adam.

Answer:Excel Formula to Word Formula

You'll have to do this:

https://support.office.com/en-us/art...4-0d7e88062257

2 more replies
Relevance 56.99%

I have created a formula in Excel that works fine, but when I put it into a MS Word table, it doesn't seem to work. The formula adds up a column of prices when the resulting column has a specific word in.
The formula is:
=SUMIF(E:E, "Yes", D:D)
Example:

Is this possible to do? If so can anyone help converting this so it will work in MS Word.
Thanks, Adam.

Answer:Excel Formula to Word Formula

Depends on which version of Word that you are using but Word can do simple calculations

2 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%

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%

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.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%

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 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%

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%

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 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 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%

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%

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 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 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%

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%

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 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 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%

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 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.53%

Hello,

I have currently tasked myself with what i thought was an very easy and simple job of being able to set up a way of having an automated email system which uses excel data.

My data contains basic information about calibration dates, i need an email (reminder) sent to a specific email address 6 months prior to the calibration date using the dates in the excel spreadsheet as a reference for the 6 months to trigger an email.

By *automated* i mean the program doesn't necessarily have to be open and doesn't require anyone to hit a command button to send off the email, it should be done without any manual interference if it is even possible to do this.

I hope you can get back to me on this issue.

Many thanks,
Ryan
 

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%

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.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%

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 54.12%

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

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 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%

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 53.71%

Dear Team,

I have gone though the below thread, which helps somewhat on my requirement but not completely. Please need you kind help on VBA code. Sorry if i have missed any other thread which would have met my requirement.

https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

Here is my requirement...
I have a data in excel (attached file) basically its a re-assigment project which needs 3 tasks.

Column A to E are filled manually which need not be automatic.
Column F has a formula for 29 days date for Column B and accordingly Column H for column F.
Column G & H are the status of task action.
every day we are manually opening the WB and checking for daily pending assignments in column H & F for today's date.

Can you please help me with a VBA code which should send a email notification/reminder not to individual email addresses instead it should send an email to me, If the Column F & H has today's date i.e. current date with the table of data in body of email and update the status as Done in excel sheet once the email has triggered.

Hope you will help me on this. Many Thanks in advance

Example of email
 

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 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 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 52.07%

Need help with the below excel formula to ensure the maximum value doesnt exceed 1200 - Can anyone help?=IF(AB14>59,Z14+1,ROUND(Z14+AB14/100+0.0005,2))[email protected] by moderator: email address deleted

Answer:Excel Formula Help Excel 2010

Ok, so did my suggested formula wok for you or not?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 52.07%

Hello All,
I am having excel file aaa which is saved on my one drive . File aaa has refrence from file bbb which is saved on local drive of my laptop. Is it possible if i use aaa from another machine and if a make any changes in bbb from my computer will that reflect in aaa.

More replies
Relevance 51.66%

I need a reminder for the syntax here.

I've got a field "ACTIVITY", which is something like this:
12345-67-89

And I need to make a new field, with just the center values, the "67"

I know there's a way to do this easily, but I'm either using the wrong command, or the wrong syntax -- I've done this kind of thing before but my brain is frozen up or something.

Much thanks!
J.
 

Answer:Solved: ACCESS question: need a reminder

DING!... light went off, got it.

thanks.
J.
 

2 more replies