booked

I have a sheet with a table listing each train we have based on the unit number, e.g.: <tbody> Start End Class Vehicles Seats 101000 101999 101 2 40 108000 108999 108 3 60 </tbody> I also have another table with the diagrams and which unit is booked to work each diagram, e.g. : <tbody>...

https://1drv.ms/x/s!AvjBsEPEq12ngR1M8FneK-3B1Ew7?e=1pqHkd Hey guys, Let me explain my setup. This workbook is what I use to manage invoices that we pay to other companies. Company (1) sends us invoices. We'll pay them. Each week, Company (1) will send us a statement with a list of...

I have a table on one sheet called BOOKINGS that has information for who booked a room, what room they booked, the date and what resources they need. I can look up and display every entry for a particular room easily enough but what I'd like to do is to display only the entries for that room...

Hi all, please help: I work in a hospital. Front office team answers the phone and books doctor appointments for customers. Our system registers the time and date of the appointment and who booked it. I want to count how many appointments were booked by each team member, per time frame. On the...

Hi I have sheet1 (project dates) set up like this: Start Date | End Date | Initial 15/01/2019 20/01/2019 BF 16/01/2019 16/01/2019 FB 01/02/2019 14/02/2019 BF 15/02/2019 28/02/2019 FB ...and sheet2 (booked holiday) set up like this: Holiday Date | Initial...

Hi - hoping someone may be able to help please. This is way beyond my level of knowledge: I have one set of data from a meeting room booking system (booked data) in one tab and another set of data from sensors in the meeting room (actual data) in another tab. I want to compare / match various...

My data is structured as below (snippet of data) <tbody> ID Location Status AP001 Location5 Booked AP002 Location3 Pending AP003 Location2 Lost AP004 Location7 Lost AP005 Location4 Booked AP006 Location2 Lost AP007 Location6 Lost AP008 Location1 Booked AP009 Location7 Lost...

Hi, Hopefully this will be n easy question. In my active sheet I have an identifier in cell D5. Based on that ID I want to delete all rows in a sheet called "All Remotely Booked Txn Table" that do not have that ID in column B. For example, if my ID is 982 I want the macro to delete all rows...

Hi all Is there a way to count non blank cells between 2 dates ? I have a holiday planner and would like to know how many days holday each person has taken from the start of year to now. In the example below are the holidays booked , i need to know how many H's are between 23/04/2018 and now ie...

I'm trying to learn about basic array formulas. Following is my example: Booked Actual 33 32 9 16 8 6 21 30 27 25 16 16 13 43 19 49 Formula: {=sum(c4.c11>=b4.b11)} - entered without the brackets, using...

Hi all, I'm not even sure if this is possible but I just wanted to see if there was a better solution to something I am struggling with. I am trying to remove duplicate instances from a list of training attendance. People are free to book on a course themselves but the problem from a...

Hi, new member to the forum here. Your help would be much appreciated. I'm beginning to build a dynamic dashboard to show the current state and availability of system environments however I'm struggling with displaying the data in the correct format that I want from a pivot table and chart. I...

I have an open order file. I want to give everyone who pre booked 5 months in advance a 3% discount. I have a start date column and a booked date column. Is there an easy way to highlight my cells if this formula is true. i hope this makes sense.

i would like to do conditional formatting between a range of dates <tbody> <tbody> August 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31...

Using PowerPivot I am struggling to create a measure to do the following: I have a bunch of projects that people book time to. Hours are booked to either capex or opex tasks. I can create measures to compare time booked to capex or opex. What I would like to do is: Filter out all the...

Hello, I have sheet one that has all the calendar dates and spaces. Sample Sheet a <tbody> WA WA1 WA2 WA3 WA4 1/1/2019 1/2/2019 1/3/2019 1/4/2019 </tbody><colgroup><col><col span="5"></colgroup> Sheet 2 has the locations with the dates they are booked...