1. C

    Warning message if it is left "X" cells left

    Hello eveyone! I have this sheet: ABCDEFGHIJK1NI :0806100USADAS2NF :08061503TOTAL AWB514SEQUÊNCIACHECK DIGITSEQ + DIGITAWBColuna1AWBAWB25080610018061 1001047 - 8061 100180610016080610128061 1012047 - 8061 101280610127080610238061 1023047 - 8061 102380610238080610348061 1034047 - 8061...
  2. D

    Create macro that sends out emails when quantity is less than or equal to minimum stock

    Hello everybody, My current excel-file looks like this: I would like to create a macro that, once I click on it, checks if the quantity is less than or equal to the minimum stock. So in the photo, for row 2 where material number "6046100" has a minimum stock of "1" and the quantity on the...
  3. D

    If two cells are different

    I paste in a number in a cell that is linked to cell I4 (so that changes I4 cell's number) Then I paste the same number from a different location in another cell that is linked to cell E4. So that both cells stay the same all the time. Sometimes I do not paste in the cell that shows up in I4 or...
  4. F

    This formula uses more levels of nesting than you can use in the current file format.

    Hi, Im trying to run this query and getting the above alert. Any help is appreciated :-) =SUMPRODUCT(MID(0&E66, LARGE(INDEX(ISNUMBER(--MID(E66, ROW(INDIRECT("1:"&LEN(E66))), 1)) * ROW(INDIRECT("1:"&LEN(E66))), 0), ROW(INDIRECT("1:"&LEN(E66))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(E66)))/10)...
  5. B

    Disable read-only warning in yellow alert

    Is it a new thing all of a sudden that Excel is warning me that my file is read-only in the yellow security message towards the top of the sheet? Can I disable that somehow? To be clear, I want to keep the document as read-only, but I don't want to get warned about it every time I open it.
  6. Vincent Thank You

    If statement between months on hand and a date

    =IF(G74<((I74)-(MONTH(TODAY()))), "ALERT", "") <colgroup><col><col><col></colgroup><tbody> MONTHS ON O/H ALERT EXPECTED DATE 0.3 ALERT 8/30/2019 </tbody> Hello! I can't get this formula to work correctly! I'd like to have the word "Alert" added to the center cell if the difference...
  7. C

    Days between dates and color coding

    So I have specifation register listing 300 products, the date the specifcation was issued and the date the specification expires. Specifications expire after 3 years. I want to keep my specifcation file current by checking the difference between todays date and the expiration date. If the...
  8. A

    Macro to answer Alert question

    Hi all - I have a macro that will open a bunch of files, update the links, and save them. Occasionally a link can't be updated and an alert pops up. Is there a way in the macro to answer that pop-up? I want to code "Continue" to the Alert. Any help would be most appreciated. Amy
  9. H

    Alert - First Monday of the Month

    I'd like to have the word Project appear in cell E2 on the first Monday of each month. Any ideas on how to do that?
  10. kelly mort

    How to fix dynamic chart data error

    Hi I have these formulas I am using to plot my charts to keep track as the data expand and shrink . =Offset(DataSheet!$B$2,,,CountIf(DataSheet!$B$2:$B$12,"<>")) =Offset(DataSheet!$C$2,,,CountIf(DataSheet!$C$2:$C$12,"<>")) It's working great just that when the cell B2 or C2 becomes blank...
  11. N

    how to create an excel popup on timer?

    lets say i have a task. i put the start time in excel. i want excel to popup alert me when time is up. how do i do that?
  12. F

    A log of when an Excel document has been opened

    Hi, I have a document of someone else's that I check daily and it was made aware to me that the individual whose document it is, knew that I was doing this. And I wasn't sure how this was possible. As far as I know, there's no way to log when an Excel or Microsoft document has been opened...
  13. kelly mort

    Count images larger than a give size in a folder with vba

    Hello again, I have been searching the net for a while now to find a solution to my problem. I have come close in most cases but not right to the point. I want to go to a folder called "MyImages" in the location on my workbook. That's. ..... ThisWorkbook.Path & "\MyImages". Then I count...
  14. S

    Alert from excel file

    Hi all I have excel file with macro. Now my file popup alert when open and not allow to save file without save new one. Pop up alert like the image I attack, please tell me wha't the matter with my file. Thanks./.
  15. P

    VBA - Pop alert for list of dates

    Hello all, First of all, I tried to find a similar thread but without much success (as I'm new) for my question. So sorry, if there is already a similar thread and if yes and you have it, just point me to the right direction. Thank you. So I have a list of client contracts and I would like...
  16. M

    Alert when entering data in the workbook

    Hi all, I have a problem, i want a message to flash up when i enter specific data anywhere in a workbook (regardless of the sheet) IE. If i enter ME1 1XY in a cell i may want this to say: "Delivery probems, check list". The purpose is to alert delivery drivers if we have had problems...
  17. P

    Formula to spot upward trend

    Hi, I am looking to create some sort of formula that can throw an alert for the user if the upward trend is increasing. I need help with the algorithm For example, Months Jan, Feb, Mar, Apr, May, Jun Values 1024, 1130, 1250, 1375, 1425, 1250 Displaying this in a chart you could say the cost...
  18. D

    Disable or VBA to prevent 'Want to save your changes' alert, just want to save it without alert

    Hey guys:) I have a script that runs and closes on it's own, the problem is that sometimes i get this alert 'Want to save your changes to '***File***'? Because of this when the script closes on it's own it does not close properly. Is there any way to disable this alert message so that it just...
  19. M

    Make a range of cells mandatory if one cell is filled in as NO

    currently I have the code where I am making one cell mandatory when one cell is filled in as yes or no. I want an easier way to specify more than one cell to be mandatory when a certain cell is filled in as no code at the moment to make one cell mandatory 'Mandatory Dependant Questions If...
  20. M

    is there an easier way to make loads of cells mandatory then coding out for them separately?

    Hi, I want to make a lot of cells mandTORY, iS THERE AN EASIER WAY TO DO THIS RATHER THAN THIS CODE: After this can put no more code in as it says too many line continuations If Application.Sheets("WERS ALERT SHEET V14").Range("C5").Value = "" Or _ Application.Sheets("WERS ALERT SHEET...

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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