Find Jobs
Hire Freelancers

VBA - Inner loop - programming skills - EASY PROJECT

$10-30 CAD

Imekamilika
Imechapishwa over 6 years ago

$10-30 CAD

Kulipwa wakati wa kufikishwa
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.
Kitambulisho cha mradi: 15715557

Kuhusu mradi

4 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
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 ndani ya siku 1
5.0 (41 hakiki)
4.5
4.5
4 wafanyakazi huru wana zabuni kwa wastani $79 CAD kwa kazi hii
Picha ya Mtumiaji
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 ndani ya siku 1
4.9 (322 hakiki)
7.9
7.9
Picha ya Mtumiaji
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$50 CAD ndani ya siku 2
4.9 (119 hakiki)
6.9
6.9

Kuhusu mteja

Bedera ya CANADA
Verdun, Canada
5.0
27
Njia ya malipo imethibitishwa
Mwanachama tangu Jan 17, 2016

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.