Find Jobs
Hire Freelancers

Excel utility

$10-30 USD

Completed
Posted about 5 years ago

$10-30 USD

Paid on delivery
I want a small excel utitliy that take values in one sheet and performs some transformation rules and then output another sheet within the same file. I have attached an example input. I want to be able to populate the input file sheet and the click on “generate” on the dashboard sheet then the out file will be generated. I have put the transformation rule in the last worksheet
Project ID: 19018902

About the project

8 proposals
Remote project
Active 5 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
Hello Sir Im excel VBA macro and formula Expert :) i can generate output like in your sample from input like your sample :) please ping me now and im able to start build right now Thank you Galih
$30 USD in 1 day
4.9 (349 reviews)
7.1
7.1
8 freelancers are bidding on average $34 USD for this job
User Avatar
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$100 USD in 3 days
5.0 (19 reviews)
4.4
4.4
User Avatar
Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5+ Yrs. of Experience in EXCEL & VBA. • Knowledge of FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • Macro coding for USERFORM and other COMPLEX TASKS possible. • Password removal from Excel and VBA editor. • Work in TIGHT DEADLINE & HIGH ACCURACY. • Can start working IMMEDIATELY. Please ping me for more discussion.
$23 USD in 1 day
4.9 (18 reviews)
3.5
3.5
User Avatar
Hey, I'm interested in your project. Please send me a message so that we can discuss more. Best Regards Monirul
$25 USD in 1 day
5.0 (2 reviews)
2.5
2.5
User Avatar
Hi, I would love to work on your project. I have done Masters of Computers (MCA). I have worked on similar project (Take a look on attached sheet) I am Excel Expert by profession & have 13+ years of exp. working on complex excel sheets. Feel free to contact and discuss more abt the project Thank you
$25 USD in 1 day
4.4 (3 reviews)
2.1
2.1
User Avatar
Hi there! Taking into account your budget I propose to create an Excel Add-in that will work as a quick entry button to perform this task in any workbook you require. I established 3 days for the work, but for sure I'll be able to deliver before the deadline. Thank you so much in advance. Best regards.
$30 USD in 3 days
5.0 (1 review)
0.0
0.0
User Avatar
Dear Client, This macro will work. Just create a new output sheet and name it Output2 and run this macro to see the effect, if satisfied, i can finish it up for you for the remaining columns L to S, i couldnt paste the whole macro here due to space constraint, i can send the complete version to you via chat Thanks Sub hhh() Dim Row As Integer, Col As Integer, x As Integer, lRow As Integer Dim Rowopt As Integer, Counter As Integer, iterator As Integer Dim Coursearray(1 To 12) As String Dim Unitarray(1 To 12) As String Dim Scorearray(1 To 12) As String Dim Gradearray(1 To 12) As String Dim details(1 To 6) As String For Row = 2 To 11 Counter = 0 details(1) = Worksheets("Input").Cells(Row, 2).Value details(2) = Worksheets("Input").Cells(Row, 3).Value details(3) = Worksheets("Input").Cells(Row, 4).Value details(4) = Worksheets("Input").Cells(Row, 5).Value details(5) = Worksheets("Input").Cells(Row, 6).Value details(6) = Worksheets("Input").Cells(Row, 7).Value For Col = 8 To 19 If IsEmpty(Worksheets("Input").Cells(Row, Col)) = False Then Counter = Counter + 1 Coursearray(Counter) = ExtractElement(Worksheets("Input").Cells(1, Col).Value, 1, "(") Scorearray(Counter) = Left(Worksheets("Input").Cells(Row, Col).Value, 2) Gradearray(Counter) = Right(Worksheets("Input").Cells(Row, Col).Value, 1)
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NIGERIA
Victoria Island, Nigeria
4.9
145
Payment method verified
Member since Jun 9, 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.