I gang

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

Færdigheder: Excel Macros, Excel VBA

Se mere: 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

Om arbejdsgiveren:
( 1 bedømmelse ) Dearborn, United States

Projekt-ID: #14902055

13 freelancere byder i gennemsnit $27 for dette job

tuanthanhle

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

$25 USD in 2 dage
(0 bedømmelser)
0.0
$25 USD in 0 dage
(0 bedømmelser)
0.0
irfannazar

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

$20 USD på 1 dag
(0 bedømmelser)
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 Mere

$35 USD in 10 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0
pitr77

A proposal has not yet been provided

$25 USD på 1 dag
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0
$25 USD på 1 dag
(0 bedømmelser)
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: Mere

$25 USD på 1 dag
(0 bedømmelser)
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 Mere

$35 USD på 1 dag
(0 bedømmelser)
0.0
$25 USD in 40 dage
(0 bedømmelser)
0.0
$18 USD på 1 dag
(0 bedømmelser)
0.0
$20 USD på 1 dag
(0 bedømmelser)
0.0