room

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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