action

My countif formula use to work, but I now have my other tab its pulling from as a sql load/connection. Why is it not working now and how can I fix it please? =COUNTIFS('Issues w-out Action Plans'!K:K,">30",'Issues w-out Action Plans'!P:P,'MoEVM Summary Level'!F4) The issues w-out action plans...

Hi all (picture attached to explain this). I have an excel form that we're using for training and compliance inspections. It has 5 sections, each with a unique category. The main section is for my "Observations", and I used VBA and a button to add rows beneath it for "action items" - things I...

I have an issues & actions log i'm setting up. In the log, I have Column A prefilled ID # field; 1, 2...50 to start. Then Column B is a dropdown with values of Action or Issue. Based on the value in column B (Action or Issue), I would like add either an A- or an I- in front of the number...

Hello All I have a very large excel file with 7 million records and 45 MB in size and on doing any action like deleting column, my excel is freezing and it takes a long time to complete that action. Is there any way to make these actions on excel quicker. Thanks in Advance.

Hello, I have a problem with Excel (2016 - Office 365). In a worksheet, I use validation. Quite simple validation: valid date input list (refering with a name to a range with the list items). There are about 15 columns with validation. On some occasion (a magic action, I'm not sure what...

Hi everyone, i am sure that this question has been asked before and i will appologise now if that is so. i have searched for the answer and had no luck with achieving my objective. i will attempt to explain this and make it easy to understand, any help with this would be appreciated. Thanks in...

Hey guys, I know this is an FAQ within forums, I have been trying different solutions found via Google but nothing worked. I am using an IF statement in conjunction with a match formula and the condition outcomes for TRUE or FALSE. =IF(MATCH(C2;Sheet2!$E$2:$E$21;0);"ACTION";"NO ACTION") The...

Hello, Hope you are all well. I love my Macro's, they're great. From time to time though, I run one of my macros and something happens that I didn't anticipate. Normally, when such a thing happens I can hit the key command Control + Z and then boom! I can undo the last action that I've done...

Hi all, Can you write Macros in Access just like Excel? Is there a way to create a pop-up message when one of my columns contains "Immediate Action"? I would like the pop up to List correlating data in other columns as well. For instance, I imagine the message containing: Site: (Name)...

Hi all, Is there a way to create a pop-up message when one of my columns contains "Immediate Action"? I would like the pop up to List correlating data in other columns as well. For instance, I imagine the message containing: Site: (Name) Contact: (Name) Status: (Should say Immediate action...

Hello, I have a list of people who took an action and the date onwhich the action was performed. Some people have the same date listed formultiple actions, others have more than one date for multiple actions. I need toidentify (maybe in a new column so it can be sorted/counted in a pivot...

I really tried and tried my bestest and Googled the excrement out of this but I just couldn't win. I want to look at column "Resolution" and for every cell marked "Action Register" I want the information in column "Root Cause" to populate on another worksheet in column "Action Item". I've...

Hi Everyone, This is driving me a bit crazy. It used to be that Excel would repeat the last action I made if I pressed the F4 key. Now it no longer does this. It's not an issue with a function lock. If I press F5 I still get the Go To menu. But somehow F4 no longer repeats the last action...

Dears, good morning! I developed an application to access a web page. I encountered a problem after login. When clicking on the "Submit" button, a form will appear to select some combos, while the macro is waiting to close the form to continue, with this message: "Waiting for another application...

Hi How can I monitor a particular range and do an action if something in this range changes? I know how to monitor an entire worksheet, but not how to watch only a particular range or even cell.

I am in a .xlsm file not that it would matter in this case. I press "Record Macro", perform an action like select a cell, put in a vlookup, or I could hit any simple action, hit stop recording, but all that I see in the code is: Sub Macro8() ' ' Macro8 Macro ' ' End Sub The body doesn't...

Hello and thank you for any attention my post may receive. I have a worksheet that has one target range (P3:P500) containing formulas where if the cell in this column on the active row calculates to 3 then a message box will appear so that the user can decide to either cancel, or OK to execute...

Hi, I am new to the forum and decently new to VBA so if this is an easy solution or there are other answers available sorry in advance. I have a fairly large workbook that serves as a sort of action list that is built from user input on a separate sheet. There is the possibility that someone...

I've been trying for a while now to put a formula together but I am having no luck can anyone help me please? formula I have: =IFERROR(VLOOKUP(B7,'SHEET 1'!B:AA,26,FALSE),IF(N7<>"NO","FOUND",IF(P7<>"NO","ISSUED","NO ACTION"))) What I want to do is like this (Wrote in words so I can hopefully...

Hi all, i am currently trying to create a counter which can help me select an action (A,B,C) depending on the highest value in that state. Example: First, the random counter would random between "HIGHEST" or "RANDOM". The probability of the random counter would be 90% "highest" and 10%...