+ Reply to Thread
Results 1 to 5 of 5

Updating one cell with the information in a cell on another worksheet

  1. #1
    Registered User
    Join Date
    09-04-2015
    Location
    houston, tx
    MS-Off Ver
    2010
    Posts
    3

    Post Updating one cell with the information in a cell on another worksheet

    Hello everyone!

    I live in Texas and work in a semi-clinic. Our scheduling/room booking program is being updated so in the interim I wanted to know if there was a way to update one worksheet titled "rooms" as available/occupied depending on if that room# is chosen in the column "Room" of another worksheet labeled physician.
    I have managed to update a "physician" worksheet to be updated with who has been seen/is ready to be seen with conditional formatting. However, every patient row has a cell designated for room#. I would like some help in that anytime a room# is booked on the MDsheet it will lead to "occupied" on the main RoomSheet. If I can get help with this then I'm sure I can figure out how to apply it to the room being "available" again.

    Thanks!
    Last edited by acm3902; 09-05-2015 at 12:42 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,284

    Re: VBA/ automatic updating

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    09-04-2015
    Location
    houston, tx
    MS-Off Ver
    2010
    Posts
    3

    Re: VBA/ automatic updating

    Thanks. I've updated my thread to hopefully reflect what my main problem is.

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,953

    Re: Updating one cell with the information in a cell on another worksheet

    http://exceltemplate.net/calendar/re...-reservations/

    May this can help you
    There is a similarity between hospital and a restaurant concerning reservations of rooms
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Registered User
    Join Date
    09-04-2015
    Location
    houston, tx
    MS-Off Ver
    2010
    Posts
    3

    Re: Updating one cell with the information in a cell on another worksheet

    Oh great thanks for the link I'll look into it!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatic updating of a spreadsheet
    By Starky01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2012, 10:11 PM
  2. Help with automatic chart updating/auto updating today function
    By Tux2424 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-26-2012, 04:45 PM
  3. Automatic Updating
    By klatre in forum Excel General
    Replies: 17
    Last Post: 08-02-2010, 08:44 AM
  4. Automatic Updating
    By DeathMagnetic in forum Excel General
    Replies: 2
    Last Post: 08-26-2009, 06:18 PM
  5. Automatic updating
    By Jymoz in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-10-2008, 03:21 PM
  6. automatic updating
    By sanders in forum Excel General
    Replies: 0
    Last Post: 07-27-2006, 09:45 AM
  7. [SOLVED] automatic updating of worksheets
    By Keith Nicholls in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-02-2006, 05:30 AM
  8. Forumla automatic updating
    By Ken Hank in forum ExcelTip.com Feedback / Comments / Suggestions
    Replies: 0
    Last Post: 07-05-2005, 08:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1