bed

  1. T

    Lookup and return all values in a row

    I have a table that follows the same structure as below. Note that in my document it is a very large table (150 rows, 30 columns), so I would like to keep the general formatting of it. <tbody> Bob Table Peter Bed Couch Chair Jeff Bed Table Grace Couch Chair Tom Bed Couch...
  2. M

    Creating a sleep/wake log - need to calculate average sleep and wake time

    I have created a sleep/wake log for a sleep experiment where individuals enter in the time they went to bed at night on Row 2 and the time they got up in the morning on Row 3 for 7 days. I have a formula at the end of each row for those 7 days that gives me the average time in bed and average...
  3. R

    VBA and pasting into a table

    Hi all I've done my utmost to find solutions elsewhere but despite my best efforts I'm still lost. I'm trying to set up a bed board for a hospital ward, I've managed the basics, setting up a table to record who is in what bed, but I need now to be able to archive the patients when they leave in...
  4. M

    re-work this macro (create new row)

    Instead of "find next row to paste to on Discharges", how could I have this macro create a new row between row 1 & 2 to paste to information there. This way, my most current information would always be on top. Private Sub CommandButton1_Click() Dim lr As Long Dim r As Long Dim...
  5. H

    Conditional Format

    Hi, I am preparing a textile worksheet where i have to enter the required and achieved bed sheet sizes. For Example Cell A1 = 140 x 200 ( This is the required bed sheet size ) Width x Length Cell A2 = 141 x 200 ( This is the achieved bed sheet size) Width x Length the achieved size differs...
  6. A

    VBA MACROS for Bed Management System

    Greetings, I am a facility manger who is really in need of something that will work...I've tried IF statements, ARRAYs, but so far VBA has gotten me the furthest. Can anyone please assist with code for a bed management system. nothing too complex, 143 bed facility. bed numbers remain the same...
  7. SaraWitch

    Mulitiple Criteria Sum

    Hello all, I have Column A with property type and Column B with totals in separate sheet. I am trying to total "Post war parlour 3 bed" and "Pre war parlour 3 bed" to give one total for 3 bed parlours. I have tried: {=SUMIFS('Pivet Tables'!$B$3:$B$63,'Pivet Tables'!$A$3:$A$63,"Post war...
  8. C

    Dragging Formula

    Property Name <colgroup><col><col><col><col><col><col><col></colgroup><tbody> Unit Mix Rent $ Square Foot Studio D8 H8 1 Bed, 1 Bath D9 H9 1 Bed, 1.5 Bath D10 H11 1 Bed, 2 Bath D11 H13 </tbody> Property Name...
  9. X

    Unsure Macro or Pivot??

    Hello, this great, I am so lost.. I have the following inquiry... I have rather large report that I need to glean data from each morning. Below is a sample. What I would like to do is.. run a macro every morning that automatically selects certain locations from the report and creates a new...

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
Back
Top