I need to have someone automate my Excel spreadsheet so that it will do the steps I do, but automatically.

Existing elements:

1. My database of products is in Excel.

2. I have .jpg images for the products. Some of the images that the manufacturer has, does not have a product for it and some of the products do not have an image.

3. I have one column in the spreadsheet that is for the image path.

4. I have a column that shows the price for products that I pay.

5. I have several columns that do not apply.

6. I have different column heading titles in the program that is importing the spreadsheet into the program that builds my store.

What I need:

1. My spreadsheet and images to be downloaded from the manufacturer’s website, automatically.

2. My Excel spreadsheet to be setup to put the path of the images into the correct column.

3. My Excel spreadsheet to put the image path in the correct column when there is an image and leave the cell empty if there is no image.

4. My Excel spreadsheet to take the price that I pay and mark it up to the percentage that I want.

5. My Excel spreadsheet to take out the columns that do not apply.

6. My Excel spreadsheet to re-title the columns to match the import wizard’s headings.

Special note: The inventory from the manufacturer, changes frequently. I would like to be on top of the changes as frequently. This would mean that the automation would need to download the spreadsheet and images about twice or three times a day.

Habilidades: Gestão de projetos, Instalação de Script, Visual Basic, Área de trabalho do Windows, XML

Veja mais: steps to take to do a website, manufacturer's website, excel mark, need manufacturer my product, i need a manufacturer for my product, excel database visual basic, setup database excel, visual basic database excel database, excel automation download website, visual basic xml program, match products, product wizard, price match, automation excel spreadsheet, product match, excel xml database, special image, product automation, download import download, spreadsheet automation excel

Acerca do Empregador:
( 0 comentários ) Surprise, United States

ID do Projeto: #68768

8 freelancers estão ofertando em média $84 para esse trabalho


I have 6 + yrs experience in developing web and windows application. I have got Microsoft certification in .net and Vb 6.0. I have done quite lot of work in integrating Microsoft excel with database using Visual basic. Mais

$80 USD in 7 dias
(2 Comentários)

Hi I am an experienced Excel/Access/Visual Basic programmer with a lot of industry experience. I can do a high quality job within the agreed time. Please respond with a sample of the spreadsheet and the url fo Mais

$90 USD in 2 dias
(2 Comentários)

Please see PMB.

$100 USD in 7 dias
(3 Comentários)

Please check pm. Thanks, Justin

$100 USD em 1 dia
(0 Comentários)

I m working on SAP and Excel data integration. Working in a SAP company.

$100 USD in 7 dias
(0 Comentários)

I have more than 12 years of C++ programming experience and build my first "WordBasic" application in 1994 for a commercial product as an interface to Word 6. I have made another couple od Office applications, one of t Mais

$55 USD in 5 dias
(0 Comentários)

Hello, We are the software professionals and we provide IT solutions in different programming languages like VB, ASP, PHP, ASP.Net, VB.Net, SQL Server 2000, XML, Oracle, Crystal Report & J2EE also. We have great Mais

$90 USD in 5 dias
(0 Comentários)

I have quite a good experience in creating applications that has interaction with MS Excel, PDF, etc via Visual Basic Hence I am sure to provide you with the small application that suit your need Get in touch wit Mais

$60 USD in 3 dias
(0 Comentários)