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

$10-30 USD

Закрито

Опублікований

about 4 years ago

$10-30 USD

Оплачується при отриманні

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.

Excel

Data Processing

ID проекту: 24129248

Про проект

15 пропозицій(-ї)

Дистанційний проект

Активність 4 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

15 фрілансерів(-и) готові виконати цю роботу у середньому за $26 USD

@P0L

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 за 1 день

5,0

(495 відгуки(-ів))

8,0

@rashedkhanrubel

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 за 1 день

5,0

(422 відгуки(-ів))

7,7

@ksriniravi

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 за 1 день

5,0

(247 відгуки(-ів))

7,0

@TechnoGuruu

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 за 3 дні(-в)

5,0

(93 відгуки(-ів))

6,5

@beltran0404

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 за 1 день

5,0

(168 відгуки(-ів))

6,0

@paulodayto08

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 за 1 день

4,7

(77 відгуки(-ів))

5,4

@reubengi

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 за 2 дні(-в)

5,0

(25 відгуки(-ів))

5,2

@VbaStudio

Hello. I know about macros and can do it easily. ..........................................................

$30 USD за 2 дні(-в)

5,0

(14 відгуки(-ів))

3,8

@mauricioalberin

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 за 3 дні(-в)

5,0

(14 відгуки(-ів))

3,6

@CronyTech

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 за 3 дні(-в)

4,2

(3 відгуки(-ів))

2,9

@sureshoragadam

Please share your excel sheet I will share the macro, that will take care of your task.

$25 USD за 1 день

4,2

(4 відгуки(-ів))

2,3

@abranveer

I am professional excel trainer. I do all these type of jobs. I will be happy to work with you. Thank you.

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@CristianGarMon

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 за 1 день

0,0

(0 відгуки(-ів))

0,0

@mgk87

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 за 1 день