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

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 like to get some recognition on this site. Let me know. i have over 20 years experience with vba and excel

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% satisfaction. Please ping me for more discussion.

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

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 the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

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

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

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

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.

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 and and one master sheet for you. Using which you can do this work in a single click. I have done this similar work before also and have multiple years of experience in Excel and automation. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Mohan

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

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 100% Satisfaction Of Deliverable

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

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. Few of my past VBA projects. - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites You can see the reviews of the same in my profile Thanks, Archana

- 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 could be set - Have done similar color coding for contracts values falling within a range. - Coloring individual cells or rows based on conditions Excel Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl MS Accesss: - I have very good expertise in MS Access - GUI, Data entry forms, calculations and reportings. - Worked on projects Database designing from business proposal, ER diagram, creating Entity relationship, normalization, constraints, indexes. - Please review my portfolio on the recent projects in Excel and MS Access. - MS Access - Database creation, tables, forms, queries and reports. Form designing, report designing, Reports generation.

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 according to given conditions. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra

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 computer with which I can deal with extremely large and complex worksheets. Sorting can be easily automated with a VBA macro, that's no problem. For coloring cells Excel has a number of cells coloring features that are very flexibla and powerfull and maybe you may want to try them. I can show you how.

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 completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.

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?

Hi, as you described in your project description.I can make your excel sheet with conditioning color cells and data entry with perfection. I assure you the quality of work. I will satisfy you with my work then ask you for payment. Hope you will consider me once.

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 for you to click which will sort and colour code the data for you. I look forward to working with you soon. Kind regards Steve

Hi, im interested in the project i have been working excel projects like that with condicional cells, can do the job fast.