ward

  1. K

    VBA Coding Help please

    Hi I have not done any coding in a very long time but I need to work out how to create a code for the following; I want to enter information on to the first worksheet, then the code to copy and paste the data to the selected hospital and ward entered in the cells on top of the worksheet. Each...
  2. Leicester City Fox

    When you enter the postcode, I need the ward to automatically populate in the Ward Column next to it

    Hi There I have a list of postcodes and their 16 wards. I want it sowhen someone enter the postcode into the postcode column it astronomically picksthe ward relating to this postcode and fill in next column once the postcodebeen entered. Does anybody have any ideas how I could do this? Many...
  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. R

    Best way to group survey results by ward reporting % of Yes results

    Not sure how to do this. worksheet has the results of and audit. Y is that the ward was compliant for that question, N no, N/A and Unknown column A has the wards audited columns B-A0 have the answers to the survey Questions in the form of Y N N/A and Unknown Eg A B C Ward Was...
  5. A

    Extracting and calculating name of company costs in a specific range

    Hi guys, Really need your help with below if possible. Below is a table of company name and costs <tbody> Name of Company Cost To Maintain Name of Company Cost To Maintain Name of Company Cost To Maintain Chubb £30.00 Entropy £60.00 Ward £220.00 Chubb £40.00 Entropy £70.00 Entropy...
  6. D

    Userform Textbox faint text

    Hi Peeps, I hope someone can help me with my query. I have tried searching on the net but to no avail. What I am trying to do is have "Please type your name here" displayed in the textbox, but when you start typing in something, that disappears. I also need it do display in another box which...
  7. K

    VBA or other method to connect multiple pivot tables w/ different data sets to same slicer?

    I'm working on a project that will provide an overview of all of our data for the last 10 years. I have five pivot tables, all filterable by our city wards. Three are based on the same data set I've connected those three to the same slicer. However, the two remaining pivot tables work off two...

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