En cours

Excel macro to reorder data

Overview

We use a product to create sales proposals and would like the ability to import manufacturers quotes into our proposals. Our product has this capability built-in but the data must be in csv format and to be easily importable using predefined maps, the csv file needs to be formatted with specific data in specific columns. The data we receive from manufacturers is either in excel or csv format and each manufacturer formats their data differently. We are in need of a macro/script that will reformat a file from a manufacturer into a csv file.

Macro/Script requirements:

• Upon execution of macro, the user should be prompted to select the source file (an excel file or csv)

• User will also be prompted to select a manufacturer name from a drop down list (or other?). This list should be easily modified by a non-programmer (me)

• The name selected will be used to 1) populate the “Manufacturer” column in the source file, and 2) Select the appropriate mappings for file reformatting. Initially this will be a single name in the drop down list (“NetApp”) and there will be a single mapping.

o My thought would be to have different sheets in an excel file and each sheet would specify the required columns and column order for each manufacturer and if required, the data to fill empty cells. That way a new sheet could be added that would specify the mappings for each manufacturer

• After selecting the source file and Manufacturer from the drop down list, the macro/program should reformat the file as described in the attached excel file.

Compétences : Excel

Voir plus : script sheets, reformat data, new product manufacturers, need of excel programmer, manufacturer requirements, formats in excel, excel macro reorder, manufacturer needs of a product, sales excel, reformatting, netapp, need manufacturer my product, need a manufacturer for my product, macro, excel-to-csv, Excel to CSV, data mapping, c# import excel, c import excel, macro script file, excel specific, excel macro csv, excel required csv, import data macro excel, create sheets data sheet

Concernant l'employeur :
( 1 commentaire ) Scottsdale, United States

N° du projet : #2406387

Décerné à :

FIBIN

Hi, I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I am interested to work for your project. I will make sure that I deliver you the best with 100% ac Plus

100 $ USD en 2 jours
(37 Commentaires)
5.1

5 freelance ont fait une offre moyenne de 126 $ pour ce travail

bouslimi1979

Can you please attach the file? Thanks

180 $ USD en 8 jours
(31 Commentaires)
5.3
vbexcel

Excel / VBA pro - ten years experience.

149 $ USD en 3 jours
(25 Commentaires)
5.2
Teloquence

Consider it done. Check your PM for my bid details.

150 $ USD en 3 jours
(49 Commentaires)
5.2
palithams

interesting challenge, ready to work

50 $ USD en 2 jours
(0 Commentaires)
0.0