Completed

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

Skills: Excel, PHP, Software Architecture, Visual Basic, Visual Basic for Apps

See more: excel macro developer, excel programmers for hire, macro expert tutorial, excel freelancers, freelance vba programmer, vba expert certification, advanced excel vba code examples, excel programming services, 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

About the Employer:
( 47 reviews ) Dhaka, Bangladesh

Project ID: #16064203

Awarded to:

deepkankaria9

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

$10 AUD in 1 day
(0 Reviews)
0.0

6 freelancers are bidding on average $53 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 in 1 day
(154 Reviews)
6.4
$133 AUD in 1 day
(59 Reviews)
5.9
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 More

$30 AUD in 1 day
(54 Reviews)
5.1
brunanishi

Let's do it!

$15 AUD in 5 days
(0 Reviews)
0.0
solidprogrammer

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

$35 AUD in 1 day
(0 Reviews)
0.0