Create Excel/Vba Macro to rearrange order of product list for proper import format file

Cancelado Publicado Dec 2, 2015 Pagado a la entrega
Cancelado

I have an excel that is updated with products daily.

We also have an online order form - [url removed, login to view]~demo/order_form/

That we update with a manually created EXCEL file (attached) and a custom import tool created for us to update the products easily. [url removed, login to view]~demo/order_form/[url removed, login to view]

In order to get the EXCEL file we need ready for upload we need to create it manually in a format the uploader will understand for import into correct columns.

It's done in two steps because our order form has sheets that are formatted in a 2 column (pg1-7) and 3 column (8-End) page layout, and so in order for the importer to work right, the imports of the sheets needed to be separate.

I attached the excel file that we use for upload. It has 2 sheets. SHEET 1 is equivalent to PAGE 1 in url order form link, and SHEET 2 is products from pages 2-9.

Column A is product; Column D tells the importer which column to place the product in, column 1 or 2.

I need to automate these sheet creations with a macro button.

The Stock list generator excel file is filled with tables of products. I'd like to run a formula that accounts for all the cells where products will be, and have the formula

1) Create a new macro sheet and place all PRODUCTS cells from SHEET 1 cells in a ONE column order like the attached excel file. ****** Depending on which column the product is in, column B or D, you need to add a column header in this new sheet to tell the importer which column the product is being added into. For example 1 is for first product column AND 2 is for second column of products ------ 0 is for Header rows.

2) Repeat STEP 1 but this time for SHEET 2-8. This time though you don't have to worry about columns. you should need to write the formula that will grab the values from the PRODUCT cells in SHEET 2-8 and place them in a new sheet in a 1 column order with respect to their TITLE sections. You will see in the excel file and in the url, on page 2.

So two steps. Basically the same thing, but second time is even easier.....

3) Add button to header area of my main excel file to automate this sheet/file creation in Steps 1 & 2. 9 ( I'll provide to you if you are chosen, )

Excel Visual Basic

Nº del proyecto: #9029755

Sobre el proyecto

22 propuestas Proyecto remoto Activo Dec 5, 2015

22 freelancers están ofertando un promedio de $7 / hora por este trabajo

dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 260 projects. Please look at the feedback left by my employers to know more about my work. Wai Más

$14 USD / hora
(80 comentarios)
6.0
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel, please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara

$2 USD / hora
(168 comentarios)
6.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regard Más

$7 USD / hora
(79 comentarios)
5.9
someka

A proposal has not yet been provided

$21 USD / hora
(57 comentarios)
5.2
sby

Hi, there's 2 ways to finish the project Use dekstop aplication that read file excell and produce the output as you like or use macro we can do both Please contact me soon to discuss ready to work

$5 USD / hora
(15 comentarios)
4.7
macroPOL

Hello, I am Excel and VBA expert. I can complete this project. could you provide a xls file? Please note that I have 100% completion rate and 5-star feedback on projects.

$10 USD / hora
(21 comentarios)
4.5
rajafaizan

Hi, Please give me a chance to make your work done in time accordingly as desired. Besides this my expertise in MS Office, Presentations, Data Entries, Designing, PDF document, Google Spreadsheet, VBA, Macros and Typi Más

$5 USD / hora
(25 comentarios)
4.4
rinabuoy13

A proposal has not yet been provided

$5 USD / hora
(5 comentarios)
2.4
Harunorrashed86

A proposal has not yet been provided

$5 USD / hora
(5 comentarios)
1.9
pmullappilly

Hi, I am ready to do this work for a low price ($2 x 10hrs) Because of some bad experiences from some of the clients from freelancer,I would like to take up and complete the work with the following steps: 1)Share y Más

$2 USD / hora
(1 comentario)
0.7
vidiastria

Hi, I have competency with huge data on detail database seems like Sql or excel. I have interest on this project and I want to try also learn from this project. Thanks for read my proposal. Regards, Rosita Más

$5 USD / hora
(0 comentarios)
0.0
karangoel16

A proposal has not yet been provided

$5 USD / hora
(0 comentarios)
0.0
Zerazera

Hi, My name is Samuel. I worked for State Street Bank for 6 1/2 years. During that time I rose from being an Intern to being an Associate II. I worked in several roles during my time at State Street, working on acco Más

$4 USD / hora
(0 comentarios)
0.0
jaisingh07

A proposal has not yet been provided

$7 USD / hora
(0 comentarios)
0.0
rkmudo

I used to deal daily with excel macro, with my expertice i think that i can fulfill your need. I also had develop some template for entering data to access database from excel using macros

$5 USD / hora
(0 comentarios)
0.0
alokbiswas

A proposal has not yet been provided

$5 USD / hora
(0 comentarios)
0.0
safuk

Hello I have many years experience in data tranformations in order to facilitate systems integration and would be happy to provide a permanent automated solution for you. Please get in touch if you are interested. Más

$16 USD / hora
(0 comentarios)
0.0
zahidqaisar

I am willing to work will zeal and passion. Budget in this regard is negotiable. it is my first experience as freelancer however I may prove my abilities as I have other Human resources too to cooperate me in this reg Más

$5 USD / hora
(0 comentarios)
0.0
chettiarsandip

Have the relevant experience of creating macros. Will ensure successful and timely delivery as per the requirement.

$5 USD / hora
(0 comentarios)
0.0
Rikhi05

Hi I am a full time Coldfusion Developer but i have worked with some of the VBA application and sql server and during that time only i got to know that we can do so much with VBA application i have done lot of rese Más

$3 USD / hora
(0 comentarios)
0.0