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

In Progress Posted 4 years ago Paid on delivery
In Progress Paid on delivery

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.

Excel Visual Basic Visual Basic for Apps

Project ID: #21251292

About the project

47 proposals Remote project Active 4 years ago

47 freelancers are bidding on average €172 for this job

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 More

€200 EUR in 7 days
(478 Reviews)
8.3
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 More

€180 EUR in 5 days
(434 Reviews)
8.3
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 More

€200 EUR in 7 days
(267 Reviews)
8.2
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 days
(484 Reviews)
8.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 More

€150 EUR in 3 days
(141 Reviews)
7.5
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 More

€160 EUR in 2 days
(260 Reviews)
7.7
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 More

€200 EUR in 7 days
(94 Reviews)
7.5
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 More

€175 EUR in 7 days
(324 Reviews)
7.4
rashedkhanrubel

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

€150 EUR in 2 days
(394 Reviews)
7.5
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 More

€150 EUR in 3 days
(189 Reviews)
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 More

€175 EUR in 5 days
(172 Reviews)
6.9
AnowarRatul

€ 150 Only ------ In just 1 Day ----- Excel VBA Macro & Formula expert ----- 100% satisfaction first, then payment.

€150 EUR in 1 day
(359 Reviews)
6.7
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 More

€200 EUR in 7 days
(64 Reviews)
6.9
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 More

€175 EUR in 7 days
(61 Reviews)
6.5
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 More

€250 EUR in 3 days
(50 Reviews)
5.9
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 More

€150 EUR in 3 days
(129 Reviews)
6.1
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 More

€150 EUR in 2 days
(61 Reviews)
6.1
ielucerotrad1

I can do the job! I checked your specifications and attached files, I can do the job. Would discuss any details that may appear. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) More

€150 EUR in 4 days
(42 Reviews)
5.3
paulodayto08

Hi Good Day! A serious freelancer here. I want to help you with this project. I saw your instructions and attachment and yes, I can do it. Please consider my bid. I've done a lot of Reports and Templates using MS Ex More

€150 EUR in 3 days
(77 Reviews)
5.5
arash18k

Hi, I can develop such Excel file with Macro VBA, in which you will have a worksheet whit all the settings you need to prepare before generating the new "Result_filled" file, and a button named as "Generate", so when y More

€175 EUR in 4 days
(13 Reviews)
5.0