VBA Excel Template Macro

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Happy bidding :) In your intro please advise us of your exact bid and how much time this will take you, no time for negotiations

We would like to revise the attached template to use for future reports.

Data 1 Sheet was for first score and highest score from SR and SM sheets

Data 2 Sheet is what we would like to have as a final product from SR and SM sheets for the following:

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 second score by date, no matter how many assessments have been taken (column W) from the "SR sheet" for the second score by date of assessment of the client by date to be listed in column L

6. scaled score (column Z) from the "SR sheet" for the second score by date assessment of the client by date to be listed in M

7. GradeEquivalent (column AD) from the "SR sheet" for the second score assessment of the client by date to be listed in N

Repeat for third, fourth, fifth, and sixth score assessment in columns M:X

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 Z

3. scaled score (column Z) from the "SM sheet" for the first assessment of the client by date to be listed in AA

4. we want the GradeEquivalent (column AC) from the "SM sheet" for the first assessment of the client by date to be listed in AB

5. date of the assessment for the second score by date after the first assessment, no matter how many assessments have been taken (column W) from the "SR sheet" for the second score assessment of the client by date to be listed in column AC

6. scaled score (column Z) from the "SM sheet" for the second score assessment by date of the client by date to be listed in AD

7. GradeEquivalent (column AC) from the "SM sheet" for the highest score assessment of the client by date to be listed in AE

Repeat for third, fourth, fifth, and sixth score assessment in columns AF:AT

Data Entry Excel Excel Macros Excel VBA Visual Basic

Project ID: #18621459

About the project

40 proposals Remote project Active 5 years ago

Awarded to:

Mokshith30

55$ in 1 day Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vb More

$55 USD in 1 day
(35 Reviews)
4.3

40 freelancers are bidding on average $152 for this job

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without c More

$250 USD in 4 days
(329 Reviews)
7.9
seaanddream

Hi, my name is Selim. I can deliver the job in 2 days for $200. I read your `VBA Excel Template Macro` project descriptions carefully before bidding. I checked the attached template as well... I got what you need and More

$200 USD in 2 days
(302 Reviews)
7.8
deepbluetech

Hi, Had a look at the Excel template file and have studied the project description. I can deliver the requirements within a time frame of 3 days for $250. Let me know. Regards, Arul

$250 USD in 3 days
(207 Reviews)
7.4
bouslimi1979

Hi, I ll review the current macro and mae updates/fixes to suits the worklow you are describing. It will take 2-3 days to provide the final version. I m ready to start. Thanks

$200 USD in 3 days
(289 Reviews)
7.6
asin1987

Dear Employer, I will complete your job in 5 days and will charge 222usd. Thanks and Regards, Ash

$222 USD in 5 days
(160 Reviews)
7.3
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro to retrieve data from sheets SR and SM and put it in the new shee More

$200 USD in 3 days
(204 Reviews)
7.2
zekovicm

Hi there,I am Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would need around 3-4 days to get it done and the cost will be 250$. Check out my profile, More

$250 USD in 4 days
(121 Reviews)
7.2
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m More

$150 USD in 3 days
(216 Reviews)
6.8
polarjin2017

Hello? How are you? I have good experiences in "VBA Excel Template Macro " as you can see my profile for these (Data Entry, Excel, Excel Macros, Excel VBA, Visual Basic). I have been working for 7 yrs in this scope. More

$155 USD in 3 days
(86 Reviews)
6.6
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$100 USD in 3 days
(119 Reviews)
6.7
TonmoyRoy111

Dear client I can do this project for you. I am an excel pro and I have already done many projects using macro. I understand your requirements. I will complete within 2 days. Kindly contact me. Roy

$150 USD in 2 days
(320 Reviews)
6.8
macroPOL

Hello, I am Excel and VBA expert. I have seen the file. I understand the requirements. I can do it in VBA (Excel VBA macro) in 3 days. If you have any questions, I will be happy to answer. Please note that I More

$130 USD in 3 days
(97 Reviews)
6.0
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Sure Willing to take up your project. Thank you, Regards

$155 USD in 3 days
(103 Reviews)
6.2
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl More

$250 USD in 3 days
(94 Reviews)
6.1
dvcontact

Hi, After reading your project description about revising the attached Excel file to be use for future report, I feel like you have me in mind when creating the project. I have all it takes to deliver. Rather than More

$150 USD in 3 days
(48 Reviews)
6.1
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you More

$155 USD in 3 days
(99 Reviews)
6.2
lightingdavid

Hello, How are you? I am highly interested to work on the "VBA Excel Template Macro". I am a full stack Excel/VBA developer. I have more than 7 years experience. I will make sure the best quality service. Let us work More

$140 USD in 1 day
(72 Reviews)
5.7
vmadhavan15

am not a random bidder.. Please ping me if you are interested with my proposal and share more detail thank you..

$250 USD in 5 days
(34 Reviews)
5.2
citijayamala

1. I am an expert in Excel, Excel formulas,VBA Excel Template Macro, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intell More

$150 USD in 3 days
(63 Reviews)
5.6
Altantsetseg

Hi. From your project declaration, its the kind of job that I have been experienced well. I can complete your job by creating excel macro using VBA. I have been experienced in programming including Ms Excel macro si More

$122 USD in 5 days
(6 Reviews)
4.0