Find Jobs
Hire Freelancers

edit macro to add formatting based on Division and Equipment columns in "Teir" Sheet of the excel workbook.

$10-30 USD

Closed
Posted about 4 years ago

$10-30 USD

Paid on delivery
When the MACRO is RUN from the main sheet I want any data listed under DIVISION columns on the "TIER" page to be highlighted on the T0-T12 sheets ALSO IF any data under "EQUIPMENT" columns on the TIER page is also listed highlight the entire line. So when I run the macro from the main page If any data under the "Division" column on the TIER page is listed then highlight that cell on the t0-t12 sheets. ALSO IF any of the data under the "equipment" column on the TIER page is listed then highlight the entire line.
Project ID: 24129248

About the project

15 proposals
Remote project
Active 4 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
15 freelancers are bidding on average $26 USD for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with your macro. Please check my profile and contact me to discuss further details. Regards.
$30 USD in 1 day
5.0 (495 reviews)
8.0
8.0
User Avatar
Hi, I will make Visual Basic code to highlight the matched data as per your requirement with good and professional quality without any error. I have completed more then 100 project within 8 months with 5 star review. You are gentle requested to see excel project sample in my portfolio here: https://www.freelancer.com/u/rashedkhanrubel. I will deliver the project within timeline with better quality. If you want to award me the project I'd be very happy to discuss deeply about your requirement and get started for you as soon as possible. Thanks! Rashed
$30 USD in 1 day
5.0 (422 reviews)
7.7
7.7
User Avatar
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I can write a macro to check for any records in T0-T12 Worksheets that has the Division /Equipment combinations present in Tier 1 sheet and highlight those records. This macro can be run from Main Worksheet. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$20 USD in 1 day
5.0 (247 reviews)
7.0
7.0
User Avatar
Hi, As per requirements, I will update VBA macro as per description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed. I look forward to discussing the project with you and hopefully secure a long term working relationship. I am ready to work on this project now. Thanks and regards, Mohan
$40 USD in 3 days
5.0 (93 reviews)
6.5
6.5
User Avatar
Hello, I'll be glad to assist you with your Excel project. I have experience with VBA code (macros) and I can do this for you. Please contact me then we could discuss further details! Luis R
$30 USD in 1 day
5.0 (168 reviews)
6.0
6.0
User Avatar
Hi, Good Day! I can help you completing the macro for your excel file. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. I also done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$25 USD in 1 day
4.7 (77 reviews)
5.4
5.4
User Avatar
Hi there, I have good VBA experience and can create the tool you need to highlight cells and rows as you have specified. I will deliver in time and of quality. Regards Reuben
$25 USD in 2 days
5.0 (25 reviews)
5.2
5.2
User Avatar
Hello. I know about macros and can do it easily. ..........................................................
$30 USD in 2 days
5.0 (14 reviews)
3.8
3.8
User Avatar
Hello, I would like to help you with your project, I have a lot of experience in web data scrapper in Excel and VBA macros. I have a Master in Applied Computing. I have more than 10 years of experience in programming in several languages and data analysis. Great experience in data mining. Applied Mathematics, Statistics and Large Data. I have a lot of experience automating excel through macros, or external applications to excel.
$15 USD in 3 days
5.0 (14 reviews)
3.6
3.6
User Avatar
I can help you with this project. I'm expert developing applications based in Excel and VBA so I can write the macro you need to highlight the information based in the information listed under division columns. Please do not hesitate to contact me so we can further discuss the details of the project. Best regards.
$35 USD in 3 days
4.2 (3 reviews)
2.9
2.9
User Avatar
Please share your excel sheet I will share the macro, that will take care of your task.
$25 USD in 1 day
4.2 (4 reviews)
2.3
2.3
User Avatar
I am professional excel trainer. I do all these type of jobs. I will be happy to work with you. Thank you.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day Sir. I can have the work done for today. I'm software developer. My experience is over 4 years. I have also deep knowledge in Microsoft Office Tools and Visual Basic
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been Preparing excel spreadsheets with VBA codes for complex Structural design problems for last 10 years. I will try to provide a best solution for this problem in the above mentioned time
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have previous experience and enough time to complete this task as well as your requirements. Just send more details on Chat.
$20 USD in 2 days
5.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
chicago, United States
5.0
2
Payment method verified
Member since Mar 4, 2019

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.