Suoritettu

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.

Taidot: Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Berlin, Germany

Projektin tunnus: #21251292

Myönnetty käyttäjälle:

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 1 päivässä
(7 Arvostelua)
3.2

53 freelanceria on tarjonnut keskimäärin 173€ tähän työhön

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 Lisää

€222 EUR 3 päivässä
(731 arvostelua)
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 Lisää

€200 EUR 7 päivässä
(319 arvostelua)
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 Lisää

€200 EUR 7 päivässä
(179 arvostelua)
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 Lisää

€180 EUR 5 päivässä
(228 arvostelua)
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 Lisää

€160 EUR 2 päivässä
(260 arvostelua)
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 2 päivässä
(312 arvostelua)
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 Lisää

€200 EUR 7 päivässä
(83 arvostelua)
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 Lisää

€175 EUR 7 päivässä
(233 arvostelua)
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 Lisää

€175 EUR 5 päivässä
(121 arvostelua)
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 Lisää

€200 EUR 7 päivässä
(48 arvostelua)
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 Lisää

€180 EUR 2 päivässä
(55 arvostelua)
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 Lisää

€150 EUR 3 päivässä
(116 arvostelua)
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 Lisää

€150 EUR 3 päivässä
(84 arvostelua)
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 Lisää

€150 EUR 3 päivässä
(91 arvostelua)
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] Lisää

€200 EUR 1 päivässä
(119 arvostelua)
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, Lisää

€175 EUR 7 päivässä
(8 arvostelua)
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 Lisää

€175 EUR 7 päivässä
(38 arvostelua)
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 Lisää

€150 EUR 3 päivässä
(82 arvostelua)
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 Lisää

€250 EUR 3 päivässä
(33 arvostelua)
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 Lisää

€150 EUR 2 päivässä
(35 arvostelua)
4.5