Find Jobs
Hire Freelancers

VBA Excel Template Macro -- 5

$10-30 USD

Completed
Posted over 6 years ago

$10-30 USD

Paid on delivery
Please read and bid exactly what you would like for this project, no time for negotiations We would like to revise the attached template to use for future reports: 1. Using the column A "Student_Number" from the first sheet labeled "Data" 2. date of the assessment (column W) from the "SR sheet" for the first assessment of the client by date to be listed in column i 3. scaled score (column Z) from the "SR sheet" for the first assessment of the client by date to be listed in J 4. we want the GradeEquivalent (column AD) from the "SR sheet" for the first assessment of the client by date to be listed in K 5. date of the assessment that is the highest score after the first assessment, no matter how many assessments have been taken (column W) from the "SR sheet" for the highest score assessment of the client by date to be listed in column L 6. scaled score (column Z) from the "SR sheet" for the highest score assessment of the client by date to be listed in M 7. GradeEquivalent (column AD) from the "SR sheet" for the highest score assessment of the client by date to be listed in N Then... 1. Using the column A "Student_Number" from the first sheet labeled "Data" 2. date of the assessment (column W) from the "SM sheet" for the first assessment of the client by date to be listed in column O 3. scaled score (column Z) from the "SM sheet" for the first assessment of the client by date to be listed in P 4. we want the GradeEquivalent (column AC) from the "SM sheet" for the first assessment of the client by date to be listed in Q 5. date of the assessment that is the highest score after the first assessment, no matter how many assessments have been taken (column W) from the "SR sheet" for the highest score assessment of the client by date to be listed in column R 6. scaled score (column Z) from the "SM sheet" for the highest score assessment of the client by date to be listed in S 7. GradeEquivalent (column AC) from the "SM sheet" for the highest score assessment of the client by date to be listed in T
Project ID: 15792356

About the project

6 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I understand your requirement to look up 6 values each from SR Sheet and SM Sheet based on "Student_Number" field. I work exclusively on such Excel based tasks full time. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 17 MONTHS , spent at least 250 HOURS on automation in Excel every month. Proposed Milestones $30 USD - Set up workbook as per requirement
$30 USD in 1 day
5.0 (143 reviews)
6.6
6.6
6 freelancers are bidding on average $90 USD for this job
User Avatar
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you. Proposed Milestones $150 USD - Please pay me once job is 100% done.
$150 USD in 2 days
5.0 (561 reviews)
8.2
8.2
User Avatar
Greeting, I have understood your VBA excel task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic Proposed Milestones $152 USD - VBA excel project
$150 USD in 1 day
4.9 (240 reviews)
7.5
7.5
User Avatar
I can do it for you quickly and exactly . Please contact me for saving your time and your money Relevant Skills and Experience I have finished great than 90 project in this site Proposed Milestones $50 USD - Finished
$50 USD in 1 day
4.9 (95 reviews)
6.2
6.2
User Avatar
I am not a random bidder. I hope I can do this one. Please ping me if you are interested with my proposal and Thank you. Relevant Skills and Experience VBA Proposed Milestones $50 USD - final
$50 USD in 2 days
4.8 (14 reviews)
4.1
4.1

About the client

Flag of UNITED STATES
Oceanside, United States
5.0
138
Payment method verified
Member since May 26, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.