En cours

VB application to edit data from excel file

Project Description

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;

-ProductNo

-Product

-SKU

-Oem

-Price

-Quantity

-Weight

-Brief

-Description

-Thumbnail

-Photo

-ExtText1

-ExtText2

-ExtText3

-ExtText4

-ExtText5

-ExtText6

-Active

-Mpn

-NaturalSearchKeywords

-NaturalSearchDescription

-Keywords

-Category

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.

Compétences : Programmation C, Traitement de Données, Excel, Microsoft Access, Visual Basic

Voir plus : why programming is important, we excel, top down programming, top data, sample product brief, rest programming, questions to ask, programming in excel, programming for excel, on line photo edit, is programming hard, how to do programming, how hard is programming, find it application, excel to application, excel data programming, excel c# programming, data programming, c programming find output, bottom up programming, ask excel, vb in excel, programming with excel, new excel, how to photo edit

Concernant l'employeur :
( 22 commentaires ) bangkok, Thailand

N° du projet : #1010762

Décerné à :

djucuti

Hi, please check PM

100 $ USD en 1 jour
(27 Commentaires)
5.0

43 freelance ont fait une offre moyenne de 128 $ pour ce travail

rhomeu

An experienced MS Access VBA developer is her Please check PM attached demo is included.

150 $ USD en 1 jour
(42 Commentaires)
6.5
sandymra

Please check PM!

250 $ USD en 4 jours
(55 Commentaires)
6.5
bharanisrihari

Hello, Excel VBA expert here. Just completed similar projects. Please check PM for details. Thanks!

200 $ USD en 5 jours
(65 Commentaires)
6.5
ineedWorkJob

sir plz check pm !

80 $ USD en 3 jours
(131 Commentaires)
6.4
srinichal

I can deliver the same asap

180 $ USD en 8 jours
(71 Commentaires)
6.2
koolsidz

Please See PMB

250 $ USD en 1 jour
(105 Commentaires)
5.8
sachinsanchela

Please check PMB.

130 $ USD en 2 jours
(62 Commentaires)
5.7
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

250 $ USD en 6 jours
(40 Commentaires)
5.6
djain01

Pls check Pmb. Thanks djain01

100 $ USD en 1 jour
(61 Commentaires)
5.5
tamrakar81

Hi, Please check PM . Thanks, T

200 $ USD en 0 jours
(46 Commentaires)
5.3
dev3dworx

Please check PMB for details.

300 $ USD en 5 jours
(20 Commentaires)
4.7
ntiersolutions

Hi, Please check PMB, Thanks.

140 $ USD en 6 jours
(23 Commentaires)
4.7
instech

Please see the PM for my bid details and suggestions.

140 $ USD en 7 jours
(6 Commentaires)
4.6
SmartGuru

Hello, Will be glad to deliver you a solution in VB.Net. Kind regards.

75 $ USD en 3 jours
(15 Commentaires)
4.5
oFAZo

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

175 $ USD en 2 jours
(16 Commentaires)
4.2
braghunath

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]

135 $ USD en 5 jours
(3 Commentaires)
4.1
piyushdpatel

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

50 $ USD en 2 jours
(10 Commentaires)
4.0
muthumuni

Hi kindly check the message box.

30 $ USD en 2 jours
(12 Commentaires)
3.9
VenturSum

MBA-Finance, 15 years developing Excel applications - Please See PM.

187.5 $ USD en 2 jours
(2 Commentaires)
3.5
jeffrmanley

I have over 7 years experience writing custom VBA code for Access and Excel. Please see PM for my project plan.

150 $ USD en 0 jours
(1 Commentaire)
3.4