I have a worksheet that I set up with 47 tables I need to be able to insert a row above the last line of each of table and copy formulas, cond. form. but not values. I have a code but excel has to reference it 47 times and in turn it takes for ever to complete and it copies cell format...
I need to find a way to sort each line by Column A and then by Column D. The problem is that some events happened at the same time. The idea is to provide a timeline of each Incident Number in Column A. How can I get excel to know that if the timestamp is the same, the line that goes first is...
So I have a table with a list of loads of different references with dates assigned to them and also 'yes' or 'no' assigned to them. I need to return the reference numbers if the date is in a specific period and they have 'yes' assigned.
Jan-Mar 2019 & Yes...
I am trying to create a spread sheet version of a project/ job board our job board look like this.
Week Commencing Date:
Engineer List/Assigned to
Engineer List/Assigned to
I'm trying to use a contains criteria to pull a time stamp to a new cell. I have tried everything I know. Below is what I'm working with. I'm trying to take the time stamp in the first column and put it in the last column but only if the middle column contains the word "Alerting"...
I’m not sure if anyone can help me?
I’m trying to write an excel query and have gotten completely stuck.
I’m wanting to write a query that looks at data and gives a response based on the data it queries. It’s actually for fault finding fixed assets for lighting. If we have...
I'm trying to work on creating a spreadsheet that will automatically assign cases to available users evenly (Assigned user goes in column A)
For the attached example I have 217 cases and 13 available users. I need items assigned out as a priority as follows:
Cases with "Late...
I was performing some edits today ... creating a new macro for a worksheet to run when that sheet is activated.
Strange thing occurred ... I noticed that a graphic object on that sheet that had an assigned macro no longer functioned. I right clicked on the graphic object and noticed that there...
I have a font which has graphic symbols that I what to use in Excel.
The font works perfectly in Word, but in Excel it displays the font letter instead of the symbol that is assigned to that letter in the font file.
How can I get Excel to display the symbol that is assigned to that letter?
assuming there is a team of 3 employees named a, b and c who have to be assigned a task as shown below.
They have to be assigned task in the same sequence as it comes. i.e. First task to a, second to b and third to c (the last person), when the fourth file comes it has to be assigned again to...
Wondering if anyone has any VBA laying around that can help me build a ticket assignment queue.
I'm trying to create a "round robin" ticket assignment queue that will keep track of tickets assigned to individuals. There needs to have the ability to skip names if their cell is shaded red...
Maybe my sheet is inefficient but what i am trying to do is have a task list scheduling tool. Basically I have a list of 30K tasks that can be assigned to various team members. Each task has a certain amount of time allowed and a start and end date. If a task takes 5 hours and we have the...
I'm using solver for stock portfolio optimization. The solver changes weights to achieve maximum expected return. I have set the following constraints: The portfolio should consist of at least 5 stocks (out of 10) and maximum weight assigned for one stock is 30%. In this case the solver...
Is there away to change my time date time stamp to 8:00 AM. The reason im doing this is I'm trying to get the the amount of minutes it takes for an engineer to contact a customer.
For example Assigned time is 1/3/2019 7:45 AM, but i cannot use this cell for my calculation because...
I am working on a Separation of Duties Form and I need a way to highlight or strike through a name if it is showing in multiple columns (Duty 1, Duty 2, Duty 3). The Form has 3 columns. The goal is if a name (Karen) is assigned in all three columns then we would like either a strike through her...
Ok, not sure if I am asking way too much of Excel here.
If I have 50 numbers, each of which are assigned a date e.g.
And I have a table/dataset in another tab...
I have written a macro to draw many on shapes on a sheet, plus another to delete the shapes.
I have then assigned the macros to two button on the worksheet but unfortunately my macro to delete the shapes also deletes the macro buttons.
Does anybody have any suggestions?