Đang Thực Hiện

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

Kỹ năng: Excel Macros, Excel VBA

Xem thêm: 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, macro query csv files, csv files easy populate, browse csv excel macro, graph csv files excel, plotting csv files excel

Về Bên Thuê:
( 0 nhận xét ) Dearborn, United States

Mã Dự Án: #14902055

Đã trao cho:

zhouming2017

Hello I would like to tell you this project is very interesting. I've rich experieneces in excel vba and macro I can do this project on time Hope for your kind contact Thank you very much. Relevant Skills and Experie Thêm

$15 USD trong 1 ngày
(0 Đánh Giá)
0.0

15 freelancer đang chào giá trung bình $26 cho công việc này

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 trong 1 ngày
(1 Đánh Giá)
1.4
tuanthanhle

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

$25 USD trong 2 ngày
(1 Đánh Giá)
1.0
$25 USD trong 0 ngày
(0 Đánh Giá)
0.0
irfannazar

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

$20 USD trong 1 ngày
(0 Đánh Giá)
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 Thêm

$35 USD trong 10 ngày
(0 Đánh Giá)
0.0
pitr77

A proposal has not yet been provided

$25 USD trong 1 ngày
(0 Đánh Giá)
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 trong 1 ngày
(0 Đánh Giá)
0.0
$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
daniel1994taheri

Hi. I am ready to co-operate with you. I also can use VBA programming and macros in excel to do your project. Waiting for your responce.thanks.

$15 USD trong 1 ngày
(0 Đánh Giá)
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: Thêm

$25 USD trong 1 ngày
(0 Đánh Giá)
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 Thêm

$35 USD trong 1 ngày
(0 Đánh Giá)
0.0
$25 USD trong 40 ngày
(0 Đánh Giá)
0.0
$18 USD trong 1 ngày
(0 Đánh Giá)
0.0
$20 USD trong 1 ngày
(0 Đánh Giá)
0.0