In Progress

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

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

Skills: Excel Macros, Excel VBA

See more: excel vba import multiple csv files, import csv file into excel programmatically, excel macro read csv file, excel macro import csv to worksheet, excel macro import multiple csv files, create graph from csv file, excel vba read csv file line by line, excel vba import csv file into worksheet, excel macro import csv create pivot table, macro import multiple csv files excel, macro import csv excel table, excel macro import multiple csv files, macro query csv files, import multiple csv files excel folder macro, excel vba multiple csv files

About the Employer:
( 1 review ) Dearborn, United States

Project ID: #14902055

13 freelancers are bidding on average $27 for this job

tuanthanhle

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

$25 USD in 2 days
(0 Reviews)
0.0
$25 USD in 0 days
(0 Reviews)
0.0
irfannazar

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

$20 USD in 1 day
(0 Reviews)
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 More

$35 USD in 10 days
(0 Reviews)
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.

$50 USD in 1 day
(0 Reviews)
0.0
pitr77

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
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

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
alokkhobragade1

Hi There, I can help you to provide VBA automation solution for your requirement. I have Rajesh Kumar Singh in my team who has got 13+ years of experience to provide SharePoint solutions to our clients. https: More

$25 USD in 1 day
(0 Reviews)
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 More

$35 USD in 1 day
(0 Reviews)
0.0
$25 USD in 40 days
(0 Reviews)
0.0
$18 USD in 1 day
(0 Reviews)
0.0
$20 USD in 1 day
(0 Reviews)
0.0