Færdiggjort

How to combine files and set conditional text and color in result excel file using vba?

I have two excel files, source and result. They both have more than one sheet, however, only the one which opens when the file is double-clicked is important (but would be great to somehow tell the vba how the sheet to be used is named, so that I do not have to delete the other sheets in the worksheet in order to get the vba running).

Result file already exists, however column action in the result file in the attachment is filled to help explain how the calculated result should look like. This would be empty. But the other columns are existing already.

I want to create a VBA excel file, which I put into the same folder as the source and the result file. The VBA file should run when I click on generate and fill the action column according to specific rules:

1.) The main point: fill in the action column in the result file, depending on the number column in the source file for each specific ID (so the calculation needs to be done for matching IDs).

- if the number is empty then fill in the number column in the source file with "Text B" and background-color to be read in from given user entries.

- if number is smaller than threshold 1 (but not empty, 0 is also accepted as a valid number) leave the field in the action column empty

- if number is larger to the threshold 1, put into "Text A" with background-color to be read in from given user entries

- if the column variable b in the result file has a certain background color (to be read in) with text "ACTION NOT NEEDED", then the action column should be filled with the text "action needed?" with red background color, regardless of the number in the source file

- if the column variable b in the result file has a certain background color (to be read in) without text "ACTION NOT NEEDED", then the action column should be filled just with red background color (also regardless of the number in the source file)

- if the column variable b in the result file has a certain background color (to be read in) regardless what text is in), then the action column should be filled just with blue background color (also regardless of the number in the source file)

- if the column variable a in the result file has certain background color (to be read in) (regardless what text is in), then the action column should be filled with text "more info needed" (also regardless of the number in the source file)

- special case is if the category variable in the source file shows "F":

- if the number is smaller than the threshold 1 (but not empty, 0 is also accepted as a valid number) then the action field should be empty

- if the number is larger than the threshold 1 the action column in the result file should be filled with text "decision pending"

- if no number is given (so the number field is empty), then it needs to be filled with "Text B" and yellow background-color

I want to "read in" the background colors (not give specific RGB or so). The specification where the number column is and where the action column should be filled is explicitly given by the user, same for variable a and b column. (As the source and result files are quite large, this can be also something like "BX" or so, here for simplicity its F, E, C, and D).

When generate is clicked, the code should create a file Result_filled which is the result file with the filled action column.

2.) Second point: check matching ids and names (to be placed in additional sheet).

1.) if there is an ID which is in the source file, but not in result file

2.) if there is an ID which is in the result file, but not in source file

3.) if there is a mismatch between names and if yes identification key should be given and name from source and name from result (to see differences).

ID column is split into two columns, needs to be joined to give an unique ID. And ID numbers are given in text format. Names of the id columns should be read-in fields. Check attachments.

Evner: Excel, Visual Basic, Visual Basic for Apps

Se mere: stringbuilder textbox text color, chane text color occommerce, change text color externally flash, change oscommerce background text color, joomla text color selected, window text color text box, modify flash text color, text color livejasmin, oscommerce change categories text color, combine files exe project, flash set static text value, import text file excel file using vbnet, richtextbox set text color, set thumbnail excel file image vba, count records text file using vba access, changing worddoc color word file using vba, joomla set article text color css, php write query result excel file

Om arbejdsgiveren:
( 0 bedømmelser ) Berlin, Germany

Projekt ID: #21251292

Tildelt til:

boscojfelix

Dear Sir / Madame, I'm interested in your project. I have worked out free sample for you. Please find the sample output of my work in this link: [login to view URL] Thank You J Felix Bosco

€150 EUR på 1 dag
(7 bedømmelser)
3.2

53 freelancere byder i gennemsnit €173 på dette job

jaylancer43

Hello, 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 (goo.g Flere

€222 EUR in 3 dage
(731 bedømmelser)
8.5
schoudhary1553

Hello, 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 several projects like this. For evidence you can see my profile. Pl Flere

€200 EUR in 7 dage
(319 bedømmelser)
7.9
asin1987

Dear Employer, Please message me to share your requirement in detail. I am an expert with over 12 years of experience and will do a perfect job asap. Please do check my previous reviews once for your kind consideratio Flere

€200 EUR in 7 dage
(179 bedømmelser)
7.6
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 perform the steps that you mention above. I plan to use Flere

€180 EUR in 5 dage
(228 bedømmelser)
7.4
zExcel

Hi, I'd be happy to help you with creating the macro to accomplish these tasks.. I'm experienced with all Excel functions including advanced formulas and macros and I have an excellent record of quick turnaround time Flere

€160 EUR in 2 dage
(260 bedømmelser)
7.7
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.

€200 EUR in 2 dage
(312 bedømmelser)
7.3
dgled

Hi, I am financial experts and a guru in Microsoft Office/Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (automation) including preparation of gra Flere

€200 EUR in 7 dage
(83 bedømmelser)
7.1
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Flere

€175 EUR in 7 dage
(233 bedømmelser)
6.9
nagyzoltan68

Hello, I would like to work on your project. I have great experience using excel macros / vba, data formatting and data manipulation in excel. In order to complete this work I will need further guidance from your side Flere

€175 EUR in 5 dage
(121 bedømmelser)
6.5
dvcontact

Hi, Would you like to see a quick demo of your project on writing an Excel VBA that fill the action column in your Excel files when "Generate" button is clicked on completed before you award the project? You can consid Flere

€200 EUR in 7 dage
(48 bedømmelser)
6.3
diorisaguilar

Hi employer! I just reviewed the .xlsx files and your proposal on how the VBA file should look like. Macro code will be triggered with the button and will edit the [login to view URL] file based on your rules. This VBA file co Flere

€180 EUR in 2 dage
(55 bedømmelser)
6.3
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible Flere

€150 EUR in 3 dage
(116 bedømmelser)
6.3
SShtv

Hello, I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These Flere

€150 EUR in 3 dage
(84 bedømmelser)
6.0
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked t Flere

€150 EUR in 3 dage
(91 bedømmelser)
6.0
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Flere

€200 EUR på 1 dag
(119 bedømmelser)
5.9
vladimirmefremov

I am experienced in VBA macros and have completed several projects related to transformation and mapping of input fils to the target workbook implementing statistics and different [login to view URL] the target excel sheets, Flere

€175 EUR in 7 dage
(8 bedømmelser)
5.5
urielbaray

Hi! I have read your requirements and I am capable to deliver a quality job and subsequent assistance. please contact me. Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expe Flere

€175 EUR in 7 dage
(38 bedømmelser)
5.4
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets Flere

€150 EUR in 3 dage
(82 bedømmelser)
5.6
bhupendrayadav

I can develop an excel based VBA tool to combine files based on define parameters, conditional formatting and fulfill other requirements. Let's discuss your requirements in detail in chat or over a call. Below is a br Flere

€250 EUR in 3 dage
(33 bedømmelser)
5.2
shahinrahimi

Hi, I can write you a neat VBA code to perform all this task as exactly as you requirements. I have rich experience in excel (advanced formulas, VBA, Macro,....), and I do my best to save your time and pocket. Please f Flere

€150 EUR in 2 dage
(35 bedømmelser)
4.5