room

  1. M

    Pasting Book Page

    This macro should open up the file (Food room book 2), copy/paste the selected range into the SkutoSkutemplate and then close the page (Foodroom book 2). Range("A1:J810").Select Selection.Copy Windows("SkutoSkuTemplate1").Activate ActiveSheet.Paste...
  2. N

    Horizontal Lookup Name Search

    Hi, I do hope somebody can help me. I have 2 sheets... First Sheet Section 1 Fred Bloggs 1001 1003 1005 1007 1009 Section 2 Amy Trams 1000 1002 1004 1006 1008 Second Sheet 1002 9.2 0.00% 1 <section name="" here="">1005 9.7 80.00% 2...
  3. G

    excel If Function containing logical test from multiple dropdown list

    Hey guys, I'm currently creating a room registry and encounter this error in one of my if function :error #value I tried to googling this issue but failed without luck. <tbody> type of room no.of night extra bed room price complimentary total </tbody> 1. under number of...
  4. G

    SUMIF name and total hours are within specific date range

    Hi guys, Hopefully someone out there can help, cos this has me beat. I need to keep a total of hours, for people working shifts that can be different lengths. I have a formula in place in the ‘Shift Start’ column that does this for the month...
  5. P

    Using Lookup & Conditional Formating

    Hi, I have 2 worksheets - Course Entry worksheet and Training Room Schedule worksheet. For Course Entry worksheet, user updates data such as course title, duration, training room, etc. As for the Training Room Schedule, it shows a list of training rooms in a monthly calendar view. Once user...
  6. J

    Multiple Conditions with INDEX

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

    Formula for displaying room assignments

    This is somewhat what I have. A The following people will be in Rm 5 B John Smith C Michael Townsend D The following people will be in Rm 6 E Jennifer Tucker F Samuel Rodriguez G The following people will be in Rm 7 H Allison Taylor J Jonathan Thompson This goes on for about 25 rooms. If I...
  8. M

    Determining the first & last timestamp per day, per user

    Hi I have data that displays employees entering a security location (timestamp) and after the security process, exits the security location (timestamp) and enters the work area. Employees will then enter & exit the security area again after their shift ends. Employees can also move in and out of...
  9. G

    VBA to open selected calendar item and add recipient

    Hello, I am looking for some Code to put in Outlook so that I am able to select a few calendar items (or all) and add a new recipient (Which is a room). I think I then need to send the calendar invite on but only to new recipients (the new room). No historic instances need to be changed. The...
  10. G

    VBA to open selected calendar item and add recipient

    Hello, I am looking for some Code to put in Outlook so that I am able to select a few calendar items (or all) and add a new recipient (Which is a room). I think I then need to send the calendar invite on but only to new recipients (the new room). No historic instances need to be changed. The...
  11. D

    Please help to achieve a drop down list based on the result of another cell.

    Hi all, hope you can help... I have a cell that has a list of locations to select from. Once selected, in the cell next to it i need for it to again have a drop down list of equipment that is in the location selected. I have created tables with these lists in already in a different sheet. i've...
  12. K

    Macro to sum selected cells in a row and repeat for all rows in a column with values

    To all, I'm looking for a macro that will allow the user to select multiple cells (up to 5) in a row (Lets say E10 and G10) and then add the sum of those two cells into the left most cell selected (this will usually be the first cell selected but it's possible the user will select the calues...
  13. K

    Macro to auto highlight a column if a cell contains specified value is in a row

    To all, I'm looking for a macro that will start in cell D6 and see if the cell contains the word "Custom" anywhere in the cell and if so, highlight the column to the last row with data in it. I then need it to move over to D6 and repeat until it encounters the last column with data with it at...
  14. H

    How to pivot a data sheet to count multiple columns with Yes/No entries

    Hi I'm trying to pivot the following scenario: <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Chairs Tables Carpets Room 1 Yes Yes Yes Room 2 No Yes Yes Room 3 No No Yes etc </tbody> To give the...
  15. W

    Pivot Table to Show OR room use hour by hour

    I have a large spreadsheet that shows the in and out times of our surgical unit. I would like to construct a pivot table that would show if a operating room is being use during a given time of a day. The goal would be to eventually look at average room use over a given span of days to see when...
  16. C

    Return Numeric Value After Certain Text String

    Hi, I have a sheet with a lot of rows of data such as: <colgroup><col></colgroup><tbody> Hotel > Level 3 > Room 360 > Courtyard K 4 > Work-Complete Hotel > Level 3 > Room 360 > Courtyard K 4 > Work-Complete Hotel > Level 3 > Room 358 > Courtyard K 4A-HI.C > Work-Complete Hotel >...
  17. D

    Assigning a value based on other cell data and certain criteria.

    Hi, I manage housekeepers in a hotel and I am trying to create a spreadsheet that helps me make room cleaning assignments based on certain criteria. The sample sheet shows the 3 columns of criteria for each room. Room Type, Room Condition, Stay-C/O (Stay over vs. Check out). I also want to...
  18. A

    Block a circular reference so it can change

    Let’s say following is my situation: Sheet 1: <tbody> Wifi Intercom system Room 1 Yes Yes Room 2 No No </tbody> Sheet 2: <tbody> Room 1 Wifi Yes Intercom Yes </tbody> Sheet 3: <tbody> Room2 Wifi No Intercom No </tbody> I want to be able to make changes in both ways...
  19. J

    Meeting room data

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

    cut and paste row to new sheet

    I am fairly new to Macros. I would like to cut and paste data from Sheet 1 into Sheet 2. I need to keep the headings in Column A (sheet1) & only want to cut and paste the data from column B to column K. I am trying to keep a current room registry. So column A is all the rooms and I do not want...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top