Ολοκληρωμένο

MACRO/VBA Expert

A simple macro needs to be developed

There are two files attached:

1: export_CSV_at_12_Jan_18_04_34_48

2. Media-Clic :Output File

Every day I receive a file in CSV format which has numerous columns. So all I want is an output file like the one attached- Media-Clic.

The CSV file has many columns but we only require the Yellow ones.

How the final output will be developed,

Each line is a data of a customer who has purchased the product in COLUMN “AW” and the quantity he has purchased in Column “AZ”. Then we provide the customer with additional option to purchase 5 other products which we call UPSALE. If a customer except an up sale then it appears under “Upsell Product Sku #1” in column “BL”and the quantity is shown in Column “BO” under “Upsell Quantity #1”. And So on continues for other upsale products on COLUMN “BY CB CL CO CY DB DL DO.”

In the Output file if a customer has accepted any of the upsale product the all the data from order number ( A to J) will be repeated and then under “Product Sku #” we will put the upsale product name from Column “BL” and Quantity from “BO”

Well please understand all files may not have the same number of columns and the columns number may change and not remain the same as it completely depends on the Upsale. The maximum line in a CSV file is 1000 meaning 1000 orders and if no one has accepted any of the upsale then the file will have alot smaller number of columns the other columns will then not appear. Hence the file needs to be sorted with header names in CSV files.

Details I can explain Later

Δεξιότητες: Excel, PHP, Αρχιτεκτονική Λογισμικού, Visual Basic, Visual Basic για Εφαρμογές

Δείτε περισσότερα: expert macro vba di semenanjung, macro vba expert, vba simple macro stock prices, vba excel cut paste macro, excel macro vba select copy paste internet explorer, simple macro outlook, macro vba mail pst outlook, example excel macro vba invoicexls forum, excel 2007 macro vba update, outlook macro vba phone number, macro vba institute bangalore, simple macro code extract worksheet names, project 2007 html export macro vba, excel simple macro data comparing copy, ftp download file macro vba

Σχετικά με τον Εργοδότη:
( 47 αξιολογήσεις ) Dhaka, Bangladesh

ID Εργασίας: #16064203

Ανατέθηκε στον/στην:

deepkankaria9

I can do this Stay tuned, I'm still working on this proposal.

$10 AUD σε 1 μέρα
(0 Αξιολογήσεις)
0.0

7 freelancers are bidding on average $49 for this job

avinav606lx

Hi there, I'm an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks

$94 AUD σε 1 μέρα
(151 Αξιολογήσεις)
6.4
$133 AUD σε 1 μέρα
(41 Αξιολογήσεις)
5.6
royalcalif

"Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Thank you very much for your opportunity to bid" Relevant Skills and Experienc Περισσότερα

$30 AUD σε 1 μέρα
(42 Αξιολογήσεις)
4.8
brunanishi

Let's do it!

$15 AUD σε 5 μέρες
(0 Αξιολογήσεις)
0.0
$25 AUD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
solidprogrammer

Hi, I can do this. I am looking for first opportunity here, please let me do this. Regards, Rais

$35 AUD σε 1 μέρα
(0 Αξιολογήσεις)
0.0