action

I have the following on my worksheet (I excluded columns that don't matter for this problem). I want to make to unique hardcoded lists to the right of the main list (bolded). <tbody> C T U W X Y AA AB AC 1 Name Action Value Name Action Value Name Action Value 2 A Buy...

I know how to write an IF statement that looks at a string of text, and will perform an action if the string CONTAINS a certain "word" using =IF(ISNUMBER(SEARCH("*word*",A1)),"word","") But Is it possible to write an IF statement that looks at a string of text, and will perform an action if the...

Hi All, I’m really hoping for some help as I’ve been trying to do something on Excel for a few days now and it’s driving me mad – my VBA skills are limited at best so any help would be hugely appreciated. I’m looking to build a macro that allows me to pull rows of information from multiple...

Hi, I'm building an action tracker at work to monitor actions arising from the various meetings. Within the spreadsheet, there are numerous worksheets, all with the same sub headings. Within the sub headings there are 'Reference, 'Description & Action', 'Owners', 'Action Owner', 'Due...

Hi, I have a much more complicated code but my issue can be broken down to this simple line. Range("a1").Value = Replace(Range("a1").Value, "action ", "") Cell A1 starts off as, for example, "action 04/08/2017" (4th of August 2017, as I'm in the UK). My code removes the action part. Seems...

Hi, I have a basic 'action tracker' spreadsheet with the following columns: 1. Action Number (Unique ID) 2. Issue (Free text) 3. Action Required (Free text) 4. Target Date for Completion (Date Field) 5. Category (Drop down list - but effectively free text) 6. Risk Rating (Drop down list - but...

I have two sets of data - one is an 'Action' list and has numbers identifying them from 'A1' to 'A30'. Th other is a 'System' list and has number identifying them from 'S1' to 'S290'. The idea is that there will be a specific set of Actions such as 'A5 - take the top off a bottle' and this...