Bring data from Input file, edit information in fields and save back to Output file.
Have search option to call data from input file. Search value will be only use for to find from "ProductNo" column. So we will call the data using ProductNo.
Once we hit the search, system will bring all the information for that line, column headers are as field name and editable text boxes where the data from input brought. We will edit the information in text fields and then click on save and system will save the new information to next available row in "output" file in the same column header order in input file.
Why we need this?
We often change the information about products and we have to do it on this input excel file. It is very confusing and tiring to do it with scrolling up and down , right and left through rows. So we need this application where it will show all the information orginized in 1 page where we can edit the data from cells.
There are 90 column headers for each product, so for this application it will be hard for to make all column headers visible in 1 page. So let's make most important column headers data at the top side of the page.
Most common used fields / column headers data from input file;
All the rest of column headers data less used so they can be bottom of the page.
Please remember, application will not make any changes on input file. It will only read data from input file. Adjusted data will be saved to next available row in output file.
Input file is CSV ( comma separated ) output file must be also same CSV format.
Sorry for my poor english. If you have any questions please feel free to ask.
Attachments are sample files. In real input file there are much more products but all column headers are always same.
**When you bid please explain how you want to do the application otherwise your bid will be disregarded.
**Full payment will be done only after final delivery.
43 freelance font une offre moyenne de $128 pour ce travail
Hello, Excel VBA expert here. Just completed similar projects. Please check PM for details. Thanks!
I have been developing applications in MS Access since the year 2003. I can take up this project [url removed, login to view] of recent projects done by me attached. Thanks [url removed, login to view]
Hi This is Piyush Patel I have 6 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM
I have over 7 years experience writing custom VBA code for Access and Excel. Please see PM for my project plan.