1. 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. 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. 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. 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)...

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

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

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. 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. 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. 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. 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. 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. 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 MrExcel.com.

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

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
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