Færdiggjort

Create Excel macro or VBA to sort excel sheet and color cells

The project is basically sorting and coloring cells in an excel sheet based on a specification file.

I have Excel sheets that have many fields and I need to sort, add color and analyze. I have to do this many times per day and it is time consuming. I need a way to (1) sort on any number of fields and (2) color cells based on conditions. The project as (3) files attached. 1. Example "before" sheet (no sort and no color). 2. Example "after" sheet where the sheet is sorted on 10 fields: M1-M10 and fields that have "Y" are colored green. 3. The specifications file [login to view URL] details the fields to be sorted and the conditions to color the cells.

I am open to a better format for the [login to view URL] or better way to use the configuration, but I want to add it to every file and I need to be able to share it. I want to open the sheet, press a button and have the sort and colorize happen.

Evner: Excel, Visual Basic, Visual Basic for Apps

Se mere: example excel macro vba invoicexls forum, excel macro vba select copy paste internet explorer, excel macro vba functions cut paste, excel macro list worksheet names sheet, excel macro vba odbc querytable, excel macro vba find word, check add install excel macro vba, excel macro web query cell sheet, excel macro vba freelance job, excel macro vba coding, excel macro print specific page sheet, excel macro print sort, excel macro vba subdirectories, copy internet explorer paste excel macro vba, create form excel macro vba, excel macro post data url sheet, excel macro vba import csv text file, excel macro vba rewriting, excel macro vba tree, excel macro vba unicode string

Om arbejdsgiveren:
( 116 bedømmelser ) Oconomowoc, United States

Projekt ID: #17685981

Tildelt til:

vw64901vw

Hi There, There are quite a few ways to do this. one would be using conditional formatting another would be using a vba macro. Either way this is a simple build and i am happy to do it for you cheap as i would lik Flere

$10 USD på 1 dag
(5 bedømmelser)
2.8

40 freelancere byder i gennemsnit $41 på dette job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Flere

$55 USD på 1 dag
(632 bedømmelser)
8.3
bouslimi1979

Hi, I require a short discussion if you can. Thanks *********************************************************************************************************************

$100 USD in 2 dage
(250 bedømmelser)
7.4
schoudhary1553

Hello, I have the good knowledge of Create Excel macro. I have more than 5 years of experience in Excel, Visual Basic, Visual Basic for Apps. I have reviewed your job and can deliver you the job with 100% satisfact Flere

$70 USD på 1 dag
(271 bedømmelser)
7.5
zExcel

I'd be happy to help you with this project. Hope to hear from you soon .. .

$60 USD på 1 dag
(257 bedømmelser)
7.7
zekovicm

Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within th Flere

$100 USD på 1 dag
(75 bedømmelser)
6.7
TonmoyRoy111

Dear client I understand the scope of work completely. I have strong hold in excel And I ensure that the work will be spot on. Kindly contact me. Roy

$100 USD på 1 dag
(262 bedømmelser)
6.5
zebracaro

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

$50 USD på 1 dag
(114 bedømmelser)
6.5
satishtl

- Sorting based on the 10 field M1-M10 & Values in S1-S10 depending on which fields you want to get sorted on. - For M values if it is Y will be set green - Similarly for S1-S10 based on the condition the colors co Flere

$60 USD på 1 dag
(49 bedømmelser)
6.0
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL Flere

$17 USD på 1 dag
(65 bedømmelser)
5.7
archanaoswal

I can write a macro to sort and highlight cells as per rules specified. The rules can be as many as you like (which will follow a simple template that I will create) I have an excellent hold on MS Excel and VBA. Flere

$80 USD på 1 dag
(75 bedømmelser)
5.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. Willing to take up your project. Thank you, Regards.

$35 USD på 1 dag
(60 bedømmelser)
5.4
AlexandrUKR

i can create VBA script, which will open the file, sort, color & save as excel file with predefined formatting, please clarify possible next step

$30 USD på 1 dag
(19 bedømmelser)
5.1
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached files test-before and test-after. I can develop a macro to sort a number of fields and color cells ac Flere

$45 USD på 1 dag
(65 bedømmelser)
5.2
TechnoGuruu

Hi, I have checked your project description and attached files in details. For the automation of this work of sorting and coloring different cells based on the criteria mentioned in text file I will build one macro Flere

$99 USD in 5 dage
(44 bedømmelser)
5.1
supper5guy

Hello there, as an excel and VBA specialist, i can automate your sorting and conditional formatting or coloring process in exactly as you want it. Thanks

$28 USD på 1 dag
(62 bedømmelser)
5.1
aubrey03

I am an Excel expert with a lot of experience in creating complex formulas and macros. Feel free to contact me for details.

$30 USD på 1 dag
(46 bedømmelser)
5.1
nurnga1218

Hi, I'm Ajiz and I'm an excel and vba expert. I want to create a concept for you but file you're attached are *.txt not an excel file? can you send me the excel file?

$35 USD på 1 dag
(40 bedømmelser)
4.5
jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com Flere

$50 USD på 1 dag
(25 bedømmelser)
4.7
sdroberts

Hello I would love to help with your vba issue. I have over 10 ears experience making macros to automate tasks and I appreciate your desire to get away from this cumbersome task! I will be able to create a vba button Flere

$30 USD in 2 dage
(4 bedømmelser)
3.5
Capitan0Trueno

I am a MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, genetic algorithms and other advanced models. I have a high performance desktop comput Flere

$20 USD in 0 dage
(5 bedømmelser)
3.5