Manpower Planning

£20-250 GBP

Завершено

Опублікований

over 5 years ago

£20-250 GBP

Оплачується при отриманні

I need a logical argument coded in VBA. I want to populate a calendar dependent on if a person is assigned numerous tasks. N10 is todays date cell F is the task start date column J is the task end date column Person is Dominic C, D & E are the columns that could contain the persons name I can use the following and copy it across the calendar if I have just a few rows i.e. 14 & 15 below, but I have over 100 rows to look at and may want to add further rows. =IF(OR(AND(N10>$F14,N10<$J14,COUNTIF(C14:E14,"Dominic")>0),AND(N10>$F15,N10<$J15,COUNTIF(!C15:E15,"Dominic")>0)),"Y","N") I need this doing by end of the weekend Contact Russell Davies on 07730 518-149 rdavies@[login to view URL]

Data Processing

Excel

Visual Basic

Visual Basic for Apps

ID проекту: 18218561

Про проект

9 пропозицій(-ї)

Дистанційний проект

Активність 5 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@prasannjeetp

Hi, I am an Excel Expert with very good knowledge of VBA, formula. I can make this spreadsheet. Please come on chat for more details. Thank you Awaiting your response.

£50 GBP за 3 дні(-в)

4,4

(48 відгуки(-ів))

4,6

9 фрілансерів(-и) готові виконати цю роботу у середньому за £125 GBP

@citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

£150 GBP за 3 дні(-в)

4,7

(68 відгуки(-ів))

5,7

@DebasisB

Hi there, I am interested in the job. I can automate the task only through code behind VBA script on any manual or triggered event from sheet. Can deliver it before the end of the day. Thank you

£111 GBP за 1 день

4,7

(34 відгуки(-ів))

5,5

@sajidkhan45

Hi, I am an excel VBA expert and can get this project done by within this weekend. Please go through my profile and reviews so that you can be confident in my abilities. I have done several projects like these. Hope to chat with you soon for a quick brief Also, there is no excel file attached for me to give a firm idea. Thanks Sajid Khan

£150 GBP за 3 дні(-в)