Excel Macro to browse for .CSV files analyze them and populate a table

Devam Ediyor İlan edilme: 6 yıl önce Teslim sırasında ödenir
Devam Ediyor Teslim sırasında ödenir

I have 100s of CSV files in a folder. The name of the folders has the TEST CASE number.

You have to write Macro in the Excel [url removed, login to view] to do the followings.

1. Browse all the CSV files.

2. Analyse the CSV Files (Described below)

3. Populate Column D and E (Described below)

4. Do some conditional formatting for Pass/Fail and Yes/no.

*****************************************************

Analyze the CSV Files and populate columns in Excel [url removed, login to view]:

a. Populate Column D:

In the macro, you have to open the selected CSV file one by one and then in CSV file you have to check data in Column C. If in CSV file column C contains single value (i.e. All 0 or all 1 or all 4500 etc. ) then in "Excel [url removed, login to view]" put "No" in column D. If in .csv file column C contains at least 2 discrete values, then put "Yes" in column D of Excel Tool.xlsx. Take the Test case number from the CSV file name and match this with Column A of Excel [url removed, login to view] test case number.

b. Populate Column E:

In the CSV file you have to compare values in Column C and F. If any of the values in Column F is equal to (or 10% + -) corresponding value in column C, then put Fail in Excel Tool Column E. If in CSV, all the corresponding values are equal (or close to equal) then put Pass in Excel Tool column E.

A couple of .csv files are provided in the attachment and sample Excel Tool is provided with expected result populated for your reference

Excel Macros Excel VBA

Proje NO: #14902055

Proje hakkında

13 teklif Uzak proje Aktif 6 yıl önce

Bu iş için 13 freelancer ortalamada $27 teklif veriyor

tuanthanhle

I can do it ============================================= I have just changed price in proposal. Please consider it

$25 USD in 2 gün içinde
(0 Değerlendirme)
0.0
irfannazar

I am expert excel programmer. I can do it perfectly.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
jcrbahia

Open files and I can do the task for tomorrow., Will have an action button that I would analyze. All Cvs, and performs the required action. The analysis is very fast and everything is done by VBA code Habilidades y ex Daha Fazla

$35 USD in 10 gün içinde
(0 Değerlendirme)
0.0
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
pitr77

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
bblinki

HI, My Name is Aleksandar and I can finish your task during this weekend. Relevant Skills and Experience I have a lot of experience in VBA coding. Proposed Milestones $25 USD - Whole task

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
danielgpratidya

Hi, I've studied your spreadsheet and those csv files you sent. I have some questions below: Relevant Skills and Experience I have more than 15 years experience on Excel automation Proposed Milestones $35 USD - Comp Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0