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.
35 Freelancer bieten im Durchschnitt $1973 für diesen Job
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.
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.