Manpower Planning

£20-250 GBP

Abgeschlossen

Veröffentlicht

vor mehr als 5 Jahren

£20-250 GBP

Bezahlt bei Lieferung

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

Projekt-ID: 18218561

Über das Projekt

9 Vorschläge

Remote Projekt

Aktiv vor 5 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@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 in 3 Tagen

4,4

(48 Bewertungen)

4,6

9 Freelancer bieten im Durchschnitt £125 GBP für diesen Auftrag

@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 in 3 Tagen

4,7

(68 Bewertungen)

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 in 1 Tag

4,7

(34 Bewertungen)

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 in 3 Tagen