Excel VBA extract data from CSV place in printable batch report
- or -
Post a project like this1107
£80(approx. $100)
- Posted:
- Proposals: 13
- Remote
- #3219219
- Awarded
Google Sheets Automation, Apps script, Excel VBA Expert, Qlikview, WordPress Hack Fix, Proofreading
Bangalore
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
Trusted CRM Consultant and Data Automation Expert. Automating your business, designing your future!
Mumbai
305992195745516719110463012644631642492171158621951692642406549061955914655623148
Description
Experience Level: Entry
Estimated project duration: less than 1 week
Hi everyone,
I am looking for someone with Excel / VBA scripting experience to advise the best way forward and then to put in place a "printable batch report" using data which is being logged into an Excel .CSV and .XLSX file in real-time. A new line is logged after an individual product test has finished.
A simple form box is needed where the user is able to easily type in a "batch number" then click a button which runs a script picking out the necessary data from the live file and parameter tables (?). An additional button is needed to be able to easily print the report.
Printable report should;
1) Show the product batch information of tested parts (see example)
2) Show the amount of passed parts of the specified batch according to the pass test status.
3) Ideally list the steps of the tested product
4) Be quick, easy and user friendly (e.g. could be published into a webpage so user cannot override data or mess with fields?).
Please see the basic example report I've put together on the 2nd tab of the attached workbook. This should hopefully make it clear what is needed to be extracted from the live files. Any questions or would like to know more please ask.
I have attached 3 files to take a look at;
FCS487-test-data-parameters-and-draft-report-layout.xlsx - This has numerous tabs/worksheets showing example data with titles showing what each column of data represents, an example batch report screen with form and buttons, and then tabs of parameter tables.
FCS487-test-data-live.csv - Raw data being logged in CSV format
FCS487-test-data-live.xlsx - Raw data being logged in XLSX format
I am open to all ideas and suggestions on this please. Happy to negotiate a fair price depending on suggestions/experience/time for the work. There is potential for further similar work in the future if interested.
Thanks for your time and I look forward to your proposals,
Alex
I am looking for someone with Excel / VBA scripting experience to advise the best way forward and then to put in place a "printable batch report" using data which is being logged into an Excel .CSV and .XLSX file in real-time. A new line is logged after an individual product test has finished.
A simple form box is needed where the user is able to easily type in a "batch number" then click a button which runs a script picking out the necessary data from the live file and parameter tables (?). An additional button is needed to be able to easily print the report.
Printable report should;
1) Show the product batch information of tested parts (see example)
2) Show the amount of passed parts of the specified batch according to the pass test status.
3) Ideally list the steps of the tested product
4) Be quick, easy and user friendly (e.g. could be published into a webpage so user cannot override data or mess with fields?).
Please see the basic example report I've put together on the 2nd tab of the attached workbook. This should hopefully make it clear what is needed to be extracted from the live files. Any questions or would like to know more please ask.
I have attached 3 files to take a look at;
FCS487-test-data-parameters-and-draft-report-layout.xlsx - This has numerous tabs/worksheets showing example data with titles showing what each column of data represents, an example batch report screen with form and buttons, and then tabs of parameter tables.
FCS487-test-data-live.csv - Raw data being logged in CSV format
FCS487-test-data-live.xlsx - Raw data being logged in XLSX format
I am open to all ideas and suggestions on this please. Happy to negotiate a fair price depending on suggestions/experience/time for the work. There is potential for further similar work in the future if interested.
Thanks for your time and I look forward to your proposals,
Alex
Alex H.
100% (7)Projects Completed
6
Freelancers worked with
6
Projects awarded
45%
Last project
21 Nov 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies