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
13 freelance font une offre moyenne de $27 pour ce travail
I can do it ============================================= I have just changed price in proposal. Please consider it
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 Plus
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.
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
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: Plus
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 Plus