Geschlossen

Custom Formatting Excel Macro

Good Morning,

Our business provides a laboratory service to researchers that generates a very large amount of data daily. We need to format individual client's data in Excel and then email it to them. Currently, the data is manually copied from the BioPlex 6.1 software's screen (which also generates CSV files if you wish) and pasted into Excel. We then manipulate and format the data in order to convert it into an easy to read and usable format for clients. We are interested in having an Excel program or macro created to perform most of the formatting automatically to streamline this part of our work. The data generated by the BioPlex software is either the presented data on the final client Excel File OR it is data fields that are used to format the presented data (here after called "formatting data"). The formatting data dictates whether the presented data receives a certain background cell color or font color. The developed Excel Macro by the chosen Freelancer must automatically format / color-code cells of presented data based on the results of the formatting data from other cells. Lastly all of the formatting data needs to be removed or made inaccessible OR the final presented data needs to be saved separately without the formatting data while maintaining all of its formatting. The macro needs to be flexible as the number of rows in the final data is always different and the number of columns is often different from one data set to another.

Please see file attached for a better understanding of what we use and work with. The excel document has a number of worksheets showing the flow of formatting that we do manually and has many notes that outlines the requirements of the macro. Please do not bid on this project until you have fully reviewed this attachment and understand the notes and scope of work.

Thank you.

Fähigkeiten: Visual Basic, Datenverarbeitung, Datenerfassung, Visual Basic für Apps, Excel

Mehr darüber excel macro fill empty cells, excel macro data cell, excel macro export xml, data net web application excel macro, excel macro formatting phone, import custom csv excel macro, excel macro formatting phone numbers, good formatting excel, excel macro formatting cut paste across tabs, excel macro cut keep formatting, excel macro formatting file, clear formatting excel macro, excel macro target custom name adress, good excel macro, good looking formatting excel, custom formatting in excel, excel macro to copy data from one sheet to another based on criteria, excel macro to copy data from one sheet to another based on date

Über den Arbeitgeber:
( 0 Bewertungen ) Calgary, Canada

Projekt-ID: #23481997

35 Freelancer bieten im Durchschnitt $1973 für diesen Job

schoudhary1553

Hello, I can help you with your project - Custom Formatting Excel Macro I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed s Mehr

$2200 CAD in 10 Tagen
(364 Bewertungen)
8.0
sergiuloghin

Hello! I checked the attached instructions file. I can fill the blank template using a VBA script. All will be done at a click of a button. I am available to start. I have a big 31% rehire rate. You will not be dissapo Mehr

$3000 CAD in 7 Tagen
(297 Bewertungen)
7.7
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will convert your raw data into the template you provide. I p Mehr

$1900 CAD in 5 Tagen
(253 Bewertungen)
7.5
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed Mehr

$1690 CAD in 12 Tagen
(148 Bewertungen)
7.4
P0L

Hello, I have reviewed your attached file and I can write the macros you need for automating the formatting process. Please check my profile and contact me to discuss further details. Regards.

$2500 CAD in 7 Tagen
(348 Bewertungen)
7.4
Vlzinch

Hello, data processing and data automation are my main expertise for more than 10 years, I'm confident that will help you with your projects. I have read all the requirements, this kind of project is my main field of k Mehr

$2250 CAD in 7 Tagen
(72 Bewertungen)
7.5
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Mehr

$2250 CAD in 7 Tagen
(265 Bewertungen)
7.0
belovewriter

Hello Sir I have read the project, and It is what I can handle being a fast, proficient and effective excel data entry expert, who works with VBA as well as formula to get this work done. Let's discuss further to set Mehr

$1500 CAD in 7 Tagen
(66 Bewertungen)
7.0
(246 Bewertungen)
7.0
dvcontact

Hi, Would you like to see a quick demo of how this custom formatting Excel macro will work before you award the project? You can consider it professionally done. I have also reviewed your attached file based on your sc Mehr

$2500 CAD in 7 Tagen
(55 Bewertungen)
6.5
wsh2

Summary: Excellent MsEXCEL/VBA Programming and Data Integration/Transformation skills. Greetings Canada from the USA.. {smile} Highly experienced (25+ years) MsACCESS/MsEXCEL/SQL/VBA/VB.Net Business Information, Pro Mehr

$2250 CAD in 9 Tagen
(55 Bewertungen)
6.4
VladimirLilenko

Hello dear sir! I am ready to develop a macro for processing a group of csv files of arbitrary length in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about m Mehr

$1500 CAD in 4 Tagen
(134 Bewertungen)
6.5
c4cuteconain

Can make you a software bot to automatically format your files as per your requirements as I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowled Mehr

$1500 CAD in 7 Tagen
(81 Bewertungen)
5.9
zu02

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. I can code all based on y Mehr

$2250 CAD in 7 Tagen
(33 Bewertungen)
5.8
rashedkhanrubel

Hi, I have understand the project requirement & interested to work for this project. I will start right now. Please send a message so we can discuss more & start the project. Thanks.

$1500 CAD in 2 Tagen
(99 Bewertungen)
5.4
bestit4u

Hello Respect sir I saw your description, I can't stand the excitement of seeing the project you post on... I bet one's shirt on I have the ability to complete your project perfetly because I have experience with your Mehr

$2250 CAD in 7 Tagen
(14 Bewertungen)
5.2
(21 Bewertungen)
4.2
urmate

Hi There I am a senior software engineer with 10 years of practical programming experience. I have excellent programming and development skills in various programming languages and frameworks. I am interested in your Mehr

$2500 CAD in 20 Tagen
(31 Bewertungen)
4.3
MartinDudumi

I can be the winning bidder. Why? Because i have the proper skills on applying any vba macro. 10 years of experience working with data plus a problem solver in a quick time. I think i can help in your project and you w Mehr

$1666 CAD in 3 Tagen
(12 Bewertungen)
4.1
(6 Bewertungen)
3.6