Sorting Project
$10-30 USD
Paid on delivery
What I need is for the macro to do some sorting and labeling for me.
If the doctor (column H) is in two rooms (column F) at the same time then the macro should know that they need to be counted separately
So for example, N2 in the workbook should say “ABDO BLOCK 1” (if you need to use the entire surgeon name or even “ABDO MD” that is fine but I would prefer only the last name) and N3 should say “ABDO BLOCK 2”
The reason for this is because if you look at the times in Columns D and Columns E they overlap and I need to be able to count them separately instead of together. If the rooms are back to back and the times do not overlap then they should be counted as 1 block.
In Column M I need to know the number of the week in that specific month, for example in May 2020 “5/1/2020” was the 1st Friday of the month and “5/8/2020” was the 2nd Friday of the Month. I need it to work for all months and all weekdays.
In Column L I need it to say the weekday
Project ID: #29503418
About the project
Awarded to:
13 freelancers are bidding on average $46 for this job
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours
Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project More
Hi, Gone through the job details and happy to help you. I am an expert in excel formulas, dashboards, macros. I will be able to finish before the deadline. Thanks Ruma
Hello,there. I have checked carefully your project description and I am very interesting on your project. I have experienced with Excel VBA for more years. So I can do your project and there is no problem on my skill s More
Hi, I am an Excel Expert with Professional experince working with Excel. I believe I can do a great work for you and ensure your quality. I have more than 5 year experince with excel. Complete a lot of jobs on Freelanc More
Create a macro to sort the data by doctor, date and pt in time parse through the data for each entry and based on the rules provide the weekday, week in the month and block information.
all you need could be done using simple excel functions - macro code is no needed. the only difference will be in "blocks" - they will have no numbers. if it suits you - you can have your excel file in minutes after ac More