Đang Thực Hiện

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.

Kỹ năng: Lập trình C, Xử lí dữ liệu, Excel, Microsoft Access, Visual Basic

Xem thêm: 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

Về Bên Thuê:
( 22 nhận xét ) bangkok, Thailand

Mã Dự Án: #1010762

Đã trao cho:

djucuti

Hi, please check PM

$100 USD trong 1 ngày
(27 Đánh Giá)
5.0

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

rhomeu

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

$150 USD trong 1 ngày
(42 Đánh Giá)
6.5
sandymra

Please check PM!

$250 USD trong 4 ngày
(55 Đánh Giá)
6.5
bharanisrihari

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

$200 USD trong 5 ngày
(65 Đánh Giá)
6.5
ineedWorkJob

sir plz check pm !

$80 USD trong 3 ngày
(131 Đánh Giá)
6.4
srinichal

I can deliver the same asap

$180 USD trong 8 ngày
(71 Đánh Giá)
6.2
koolsidz

Please See PMB

$250 USD trong 1 ngày
(105 Đánh Giá)
5.8
sachinsanchela

Please check PMB.

$130 USD trong 2 ngày
(62 Đánh Giá)
5.7
nagybatonyi

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

$250 USD trong 6 ngày
(40 Đánh Giá)
5.6
djain01

Pls check Pmb. Thanks djain01

$100 USD trong 1 ngày
(61 Đánh Giá)
5.5
tamrakar81

Hi, Please check PM . Thanks, T

$200 USD trong 0 ngày
(46 Đánh Giá)
5.3
dev3dworx

Please check PMB for details.

$300 USD trong 5 ngày
(20 Đánh Giá)
4.7
ntiersolutions

Hi, Please check PMB, Thanks.

$140 USD trong 6 ngày
(23 Đánh Giá)
4.7
instech

Please see the PM for my bid details and suggestions.

$140 USD trong 7 ngày
(6 Đánh Giá)
4.6
SmartGuru

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

$75 USD trong 3 ngày
(15 Đánh Giá)
4.5
oFAZo

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

$175 USD trong 2 ngày
(16 Đánh Giá)
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 trong 5 ngày
(3 Đánh Giá)
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 trong 2 ngày
(10 Đánh Giá)
4.0
muthumuni

Hi kindly check the message box.

$30 USD trong 2 ngày
(12 Đánh Giá)
3.9
VenturSum

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

$187.5 USD trong 2 ngày
(2 Đánh Giá)
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 trong 0 ngày
(1 Đánh Giá)
3.4