Manpower Planning

£20-250 GBP

완료함

게시됨

5년 이상 전

£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년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@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일에