actions

Good Evening All, I don't know if this is possible and am really struggling with this problem. We have a sheet which lists how many actions are needed to be done and what week they will start closing them out followed by how many weeks it will take them. This way we can give them a target...

Hi all, I've managed to stump myself on what should be a fairly simple task. I have a data file with activity by time for employees. Each action has a time next to it. I'd like to create a chart that visualizes the breaks between actions so that one can see for example that someone took a...

Hi, I have a table of data, it is a list of actions for different team members, so the columns are: A1 = action number, A2 = name of the team member, A3 the Action assigned. I want to have 1 central database of actions with all of the teams work related actions on, this is the main source, BUT...

I know how to loop using this code Sub WorksheetLoop2()<code class="" style="box-sizing: inherit; font-family: Consolas, 'Courier New', Courier, monospace; font-size: 1em;"> Dim Cur As Worksheet For Each Cur In Worksheets '===================== 'This line calls for recording...

Hi, Basically when i open a specific worksheet i need two things to happen. 1,Select cell A4 2,Open Userform. I can only do one of them using the Private Sub Worksheet_Activate() I have this in use on another sheet which does the two actions BUT its written to select the bottom on my sheet...

In Excel, you can easily record a macro to create a chart and manipulate it. Alternatively you can write the code from scratch to arrive at the same result. Is it possible to record the actions / write code to automate the actions in Power Pivot / Power BI?

ActiveCell.FormulaR1C1 = _ "=INDEX('Department Adherence'!R[-16]:R[1048559],MATCH(""Department Total"",'Department Adherence'!C[-1],0),3)" Is there a way to amend this formula so that it actions the formula in column "C" only if column "B" equals "Department Stats" If column "B" equals...

I have written a macro that filters an excel sheet and emails the results to an email recipient - it uses "Send sheet" rather then send as an attachment. The problem I'm having is that when the email recipient replies to me, the sheet appears unfiltered and is causing confusion (I am sending...

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

Hi all I'm really struggling here - any help would be great. I have a spreadsheet where I am trying to record (in cell F4) that actions are either open or closed off. Where actions are open it is automatically highlighted red. I have the following formula. =IF(E4<>"","Closed","Open") all good...

Hi All, i need your help... i dont know anything abt macro..but i try to learn. i need a macro script in a way which communicate with a website and do the actions which i want. for example take a gmail webiste. i want the actions like this with the help of excel macro step 1: open the...

Hello, I am trying to Create a logging sheet with the following columns. The sheet contains items which need to be tracked and each one has a 'log' against it which logs all previous actions. There is a meeting each week and before that meeting there is a manual task where We have to append...

I have the following problem: I have Wbk1.xlsx activated and I want some code to be executed on Wbk2.xlsx : For Each rg1 In Workbooks("Wbk2.xlsx").Worksheets("Sheet1").Range(Cells(nPostingDate_Row, 1), Cells(nPostingDate_Row, nFinal_Column)) nPostingDate_Row is 12 in the example and...

I haven't been able to find any reference to controlling the actions in the Consolidate dialog box. I know the basic Range.Consolidate Sources:= But what about the other actions in that dialog box such as adding/deleting range references?

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

Hi there, I have somehow stumbled my way across to get an index function to work with a project plan. Please find spreadsheet attached. On the Project Planner snapshot sheet, you will see to the right hand side (ID) and 'Actions for the next meeting'. Using the relevant ID number, actions for...

I'm trying conditional formatting and I want to see the formula of a set cell as text in another. The conditional format of the cells is based on a number of AND/OR commands and I need to see how different actions effect the cell and understand the minor tweeks to the formula. is there a...

I have a dashboard that is created in Excel for many different departments, packaged as a PDF using the Ron de Bruin VBA and then emailed to them automatically via Outlook. At the bottom of the dashboard is a section called "Department actions." At present the only way for this to be returned...

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, Any help anyone can give with this would be really appreciated. I'm trying to create a system to track project actions and updates within excel - can't use MS Access or MS Project otherwise I would, so having to make do! I've got a separate worksheet for each project and I'm adding all...