Sorting Project

Completed Posted 3 years ago Paid on delivery
Completed 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

Excel VBA

Project ID: #29503418

About the project

13 proposals Remote project Active 3 years ago

Awarded to:

(5 Reviews)
3.3

13 freelancers are bidding on average $46 for this job

writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours

$30 USD in 1 day
(10 Reviews)
3.5
akritisood94

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

$30 USD in 1 day
(5 Reviews)
3.1
rumarahman

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

$39 USD in 1 day
(3 Reviews)
2.8
SultanovIslam1

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

$30 USD in 1 day
(2 Reviews)
2.0
Jayant222

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per More

$50 USD in 1 day
(2 Reviews)
1.2
nimiwebjuggler

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

$50 USD in 1 day
(1 Review)
0.6
BAVarun

Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 61 projects on FL. Expertise in - ○ Macros ○ Formulae ○ VBA ○ User forms Willing to share a s More

$25 USD in 7 days
(0 Reviews)
0.0
mjpeterson1223

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.

$30 USD in 2 days
(0 Reviews)
0.0
dragonbelfegor

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

$17 USD in 1 day
(0 Reviews)
0.0