Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 6 of 6 Posts

·
Registered
Joined
·
28 Posts
Discussion Starter · #1 ·
I have attached three excel files .....In the file called 'sampleBook1latest' I have a button called 'click here to clear a schedule' If I click that button and choose OR,start time and duration of a surgery then a schedule that is already created wil get cleared.....I have the total number of nurses and number of nurses used saved to the side of the sheet..... The total number of nurses at the side is read from another excel file called 'Input file for # of nurses'

Now the problem is that if clear a schedule then the number of nurses used is not getting updated at the side.....if I clear a schedule then the number of nurses at the side should also get updated....for example(If I create a schedule with 3 nurses and if only a total of 3 nurses are available then..... the used number of nurses for that specific time at the side will get updated to 3 from 0 and if I clear that schedule then the used nurses for that time should again become 0)....

The other problem is that if I schedule a surgery then all details of the surgery will be saved in another excel sheet called 'input file for patient details' so if I clear a schedule then all the details of that surgery saved in that excel sheet should also be cleared......

Thank you
Bharath
 

Attachments

·
Registered
Joined
·
28 Posts
Discussion Starter · #4 ·
Hi Tony

I thought of a logic....Please help me to do it......here it is


I tried to do some changes in userform2 ...to find a range of cells using OR and start time as input and to colour a range of cells in the 'input file for patient details' but it is not working...............I dont want to colour the range of cells but I tried it just to start with.....please check it and use it and help me to do the following

In the userform 2 we give the input as start time , duration and OR number...we can take that as input and search for the OR number and the start time and read the corresponding 'number of nurses' column in the 'input file for patient details' and subtract that number of nurses value from that of the 'nurses used' which we have put at the sides......after reading it the entire row containing the specific start time and OR number should be deleted...Please help me doing it....

Thanks
Bharath
 

Attachments

·
Registered
Joined
·
28 Posts
Discussion Starter · #5 ·
Hi Tony

You helped me to read the number of nurses from the excel sheet and update it at the sides....I used the same code to delete the number of nurses used when we clear a schedule........but it is not working.....Please have a look at my code (userform2) and help me correcting the mistake....



Thanks
Bharath
 

Attachments

1 - 6 of 6 Posts
Status
Not open for further replies.
Top