allocated

Hi, I am trying to make a process a little easier at the school I work in. 1 hour a week we have an enrichment time where different activities are offered to the children on a 6 week basis, they pick their preferences on a slip, then 2 staff members sift through all the slips and allocate them...

I am wanting to return all records in an Access table that meet a query criteria. The query I have built via VBA code is - SELECT ID, Price, QtyOut, ValueOut, InStock, ValueInStock, Allocated FROM GoodsIn WHERE Item = '9oz Squat Plastic Cup' AND DateIn <# 22/08/2019# AND Allocated = False ORDER...

So, in the attached example... I want to show forcolumn D within Programme Profile, either 'Under allocated', 'Over allocated','Fully allocated' The resource wouldbe either under, over or fully allocated depending on them being aligned to theproject and the dates they are due to undertake...

First of all can I apologise, I can read and understand formulas, but find it hard to write them. I require a formula to return a value from a row (in a table) on another worksheet (Tab 1), where the table has partial text. Tab 3 has full text (in cell) that I require the result to be copied...

Hello, I've created a resource scheduling tool for my company that is based on days per weeks, projects that each resource is working on etc. I have a sum up at the bottom to ensure that each resource is not over allocated in each particular week, but as the number of projects is increasing, i...

Hello, I've got a task given to me that's been quite manual in the past that I'm trying to speed up with the help of some vba/formulas. Basically I've got a list of products (A,B,C) with a manufacture due date that need to be allocated between 3 different people (X,Y,Z). The dates will differ...

I am currently working on a spreadsheet to show duration between several date/times displayed as DD/MM/YYYY HH:MM. I need to report on the difference between the Request time of a job versus its completion time. The only issue is, not all jobs have a requested time so i have some cells in that...

Hi Guys, I've been using excel to allocate work equally. Up until now this works ok but the formula i am using essentially looks at a list of work, looks at the staff members in the list called Blue Team Names and allocates out evenly. There are 2 tables below. To give you an idea the below...

Hi, I have a sheet which shows the dates tasks were allocated to different staff members. Can anyone help with a formula that would show the most recent date a task was allocated to each staff member (should also show where the task was allocated to more than one staff member). Using the...

Hi, I am trying to highlight if an allocated booking time goes over 30 mins - any help to do that would be great! Thanks

I have a table of customers with an allocated sales lead - I have a table of transactions for customers. I've the relationship set up in power pivot and the salesman flows through no problem. The issue I have is when the allocated sales lead changes. The pivots give amounts by salesman for...

I am working on a sheet where i have 500 A1 to A500 Id's . I have a range of data from F1 to F300. Manually allocating the data to each cell in A column is time consuming . is it possible to create a macro that will allocate range of data against each cell in column A . For Example A1 -...

Hi guys, I am looking for ideas from the wealth of knowledge within the forum - I will try to explain as best I can but I apologise in advance if I haven't explained it well. So, I have a worksheet with three columns (there can be more if needed) the first column shows the time period...

Hello, I am attempting to write a macro and the Index match formula is not computing correctly as I am returning a #N/A. Here is my formula as it appears in VBA Dim LR As Long LR = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row Range("H2:H" & LR).Formula = "=INDEX(KPI_Metrics!E2:E" & LR &...

I have the following data: <colgroup><col><col><col span="3"></colgroup><tbody> <tbody> H I J K L Case Status Allocated To Date Allocated Sate of Assessment Date Case Closed Minnie 17/03/17 26/04/17 Daffy 25/04/17 05/05/17 01/08/17 Pluto 02/05/17 10/05/17 </tbody>...

Dear All, The solution to this complex problem is beyond my capability and imagination but I know that this would be very simple to many excel gurus here in this forum. Would be grateful , if somebody could suggest a solution & it will save unwanted manual intervention that presently I am...