Find Jobs
Hire Freelancers

VBA - Inner loop - programming skills - EASY PROJECT

$10-30 CAD

완료함
게시됨 6년 이상 전

$10-30 CAD

제출할때 지불됩니다
See attachement for print screen and excel model. Input from Workbook 1 Output to Workbook 2 What you will need to do The print screen below represents a matrix that contain information from column A to column S and from row 1 to row 389. The number of row could growth. I need a VBA script which will print in a new Excel sheet the jobs tasks indicated in the column F taking into account the frequency represented by the difference between the column K minus column J (column K - Column J). Thus, if column K5 minus Column J5 equals 5 for example, this job task will have to be printed 5 times in the D column of this new Excel sheet. This must be done for all tasks between row 2 and row 389 relative to its corresponding frequency (column K & J). Then, this VBA script will also have to indicate the date on the monthly date that these business dates associated with it represent. For example, suppose the cells F5 "d", if we have the number 4 in the column J5 and the number 9 in the column K5, we know that the frequency is 5 (9 - 4). Therefore, the VBA script will print "d" 5 times. Then, each of these occasions will have to be associated the dates of the current month. Here, let's take November 2017 as an example and assume there is no holiday. Business day 4 is November 6, 2017 and business day 9 is November 13. Therefore, the VBA script should print “d” 5 times as per the following. d 06-nov-2017 d 07-nov-2017 d 08-nov-2017 d 09-nov-2017 d 10-nov-2017 This will need to be done for every task in the column F as explained. November 2017 (Country Canadian – Province Quebec Calendar) Explanation Colonne F : Text (String) => This will be some job tasks. Colonne J : Number1 => This is a number that represent the starting business day in a monthly or quarterly calendar. (this is technically the business date that represent the Job tasks starting date) Colonne K : Number2 => This is a number that represent the ending business day in a monthly or quarterly calendar. (this is technically the business date that represent the Job tasks ending date) Exemple : We have on cells F2 “a”, on cells J2 “5” and on cells K2 “5”. This is meaning the job task “a” start on BD+5 and end on BD+5 of this month. Pay attention: - When you have a negative number, this is meaning the job starting date is before the beginning current month. - When you have “S.O.”, this is meaning there is no date available for this job task. - For now, this is for a Monthly Calendar date, but eventually, it will also be for a quarterly calendar date. - Business day 1 represent the first week day of the month. You will need to think about the possibility to add some holiday that would be taking in consideration in your calculation. - The number of row could growth.
프로젝트 ID: 15715557

프로젝트 정보

4 제안서
원격근무 프로젝트
활동 중 6년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Hi, I've read your brief and I understand. May I ask your excel file? and may I do it in a document but in different sheets? so will there are input sheet and output sheet. I'm waiting your reply, Thank you.
$30 CAD 1일에
5.0 (41 건의 리뷰)
4.5
4.5
4 이 프로젝트에 프리랜서들의 평균 입찰은 $79 CAD입니다.
사용자 아바타
Greeting, I have understood your VBA - Inner loop - programming skills task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel, Programming, Visual Basic
$70 CAD 1일에
4.9 (322 건의 리뷰)
7.9
7.9
사용자 아바타
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$50 CAD 2일에
4.9 (119 건의 리뷰)
6.9
6.9

고객에 대한 정보

국기 (CANADA)
Verdun, Canada
5.0
27
결제 수단 확인
1월 17, 2016부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.