action

Hi all, I have been using an excel file to feed into a visual basic project,I have done this many times but have never encountered the following problem. First the file has taken it upon itself,without any apparent reason to become a read only file,why I dont quite know,I didn't alter the file...

Hello all, Like the title here suggests, what formula will extract characters A-Z , a-z and 0-9 from a cell. Hence omit . spaces, dots, semicolon, question-mark, exclamation marks etc. for instance. From A8^Kite? abc 450 4xsection- action? 54 12/31/2017 To A8Kite abc450 4xsection action 54...

I can't figure out what is wrong with the below piece of VBA code Range("T6").formula = "=IF(Q798*R798*S798,"TAKE ACTION","DO NOTHING")"

Hi, is it possible to create conditional formatting of icon set as an indicator of task status, i.e. if an action is "in progress", i want to show a yellow circle icon next to "in progress", if an action is "completed", i want to show a green circle icon next to it. The icon set currently in...

Hi I'm not sure if this is possible with excel but I am currently trying to simulate a reinforced learning algorithm using formulas. Basically what i am trying to do is automate a sheet whereby every time i press f9, an iterative calculation will be done in worksheet 1 and from there the...

Hi, I've got case right here.. I have 2 sheets: On Sheet 1 on row 3 in Column E there's a name and from Column F to AD are weeknumbers (1 to 51). Per action you can fill in a weeknumber which that action has to take place. On Sheet 2 I need to insert a name with rows depending how many actions...

Hello, I am trying to set up a report at work that would allow me to export an action tracker to a PDF format - the draft is here. The macro should extract information from Action tracker tab and move it to separate tabs for each issue. The format of the tabs is in Template tab. Those tabs + the...

Hello, I am trying to get this nested IF formula to work, however it keeps returning FALSE. Any help appreciated. =IF(D3="Monthly",IF(COUNTA(E3)<1,"Action Required",IF(D3="Hub Contact",IF(COUNTA(E3)>1,"Action Required",IF(D3="Bi-Monthly",IF(COUNTA(E3)<>E3/B1,"Action Required","No Action"))))))...

Hi. I created a worksheet (Actions) to track action items for a weekly call. Each call I use a new column with the date at the top (i.e. K10=1/1/2018, L10=1/8/2018, M10=1/15/2018) and enter notes for each item in the rows below it. I have created another worksheet (Dashboard) that gives a...

Hello all, I am looking for a solution for the following problem: I want to automatically merge data from several action lists into one big action list. In "C:\directory 1" the file is located where I want to combined all the data, this file is called "Merged data.xlsm", this workbook has a...

Hello, What is the command to do an action until I find a specific work in my column A? And once this word is found, stop the action. Thank you

Hello all This is my first post on this forum and needed some help on what I am trying to do. I have data that stretches across a few cells and shows the grade the advisor received in date order and the formula I am trying to build is to check they competency rating and I want the formula to...

Good Afternoon All, First time poster, long time lurker! Great forums helped me out many times! Hopefully someone can help with this quesitons? I have created an action tracker in Excel and I've used a formula to indicate if actions have past their target completion date. The formula i have...

Hi Dear All Need your help in this case I created sheet and put this macro on it to track if any cell value changed it make action Also I add this macro in module to clear it to start from beginning I want to pause Private Sub action while Macro Clear is running I hope my bad...

I know excel basics and am trying to learn more advanced options. I am trying to figure out how to transfer row information from one sheet into another sheet with similar criteria. The sheets act as steps in a process for my department. Is this achievable? I also would like to know how to create...

I have a movie database that exports the genre categories for each movie as a list within a single cell, separated by "space hyphen space" (See examples below). I'd like to generate a list of movies in each category but haven't a clue where to start. A brute force method is using the quick...

Hi I have the below to 'Clear" the cell data but ignoring cells with formula from cells A4:Z10000. It work fine when you run the macro once (when cells have data) but if you try to run again then hangs up on below "Selection Line" (in red below). If you then add any data at all in a cell...

I am trying to create a spreadsheet that will generate action plans for colleagues on development programmes. What I would like to achieve is the following: - one sheet will have an empty action plan form, including several empty cells which will be populated with the required tasks - another...

Hi there, i have this file where i use it for my To Do list in my work. and after i set the code in the file it worked like a charm, after some time (usually 1 or 2 days) the code broke and when i fill a new item on my To Do list timestamp is not appearing or updating automatically anymore...

I'm new to writing formulas in Excel, and I can't figure out how to have nothing change in one cell if the contents of another don't meet my criteria. IF (the value in B1) ISODD, C1=B2; if the value in B1 is NOT odd, take no action. How can I do that? I'm using :( Excel 97!