In Progress

excel marco required

Hi, I will be needing to run this process daily to work out the total number of items that will be sent for each postage service

Here is roughly how I would like the data to be displayed at the end of the macro

Service provider Code Number of items

City Link 3 Day SL100 15

City Link 3 Day LL100 25

City Link 3 Day LL250 226

City Link 3 Day LL500 221

City Link 3 Day LL750 55

City Link 3 Day PT750 1

City Link 3 Day PT1000 26

City Link 3 Day PT1250 3

City Link 3 Day PT1500 21

City Link 3 Day PT1750 2

City Link 3 Day PT2000 2

Royal Mail LL 1 Day All Codes 5

Royal Mail PT 1 Day All Codes 5

Royal Mail Europe AMLL 19

Royal Mail Europe AMPT 19

Royal Mail ROW AMLL 19

Royal Mail ROW AMPT 19

The file begins as a CSV file, with the following columns; Post Service cFullName dProcessedOn cCountry ChannelSKU Barcode

then I need to;

1. Delete all rows of data that has a dProcessedOn older than the today (the day the report is made) (sort by newest first)

2. Remove duplicate names, Sort by cFullName, remove duplicates

3. Sort by cCountry, split the United Kingdom from the other countries

4. Sort the UK section by Post Service, separate any 1st class services

5. Display the total number of SL100, LL100, LL250, LL500, LL750, PT750, PT1000, PT1250, PT1500, PT1750, PT2000 codes in the totals screen (take data from UK section only) (data codes found in barcode column)

6. Split the other countries in to europe and not europe, count the total number of AMPT / AMPLL (also found in barcode column)

Skills: Excel

See more: excel marco, excel remove marco, marco excel, excel macro how to, excel split columns, sort excel, excel work today, excel services, excel service, excel duplicate, excel macro sort, sort macro, excel row column, excel macro row, excel macro csv, duplicates excel, excel required csv, excel delete row, excel count, excel report macro, excel split, excel column row, excel 2013 macro, column row excel, macro report

About the Employer:
( 12 reviews ) yate, United Kingdom

Project ID: #4668425

Awarded to:


Looking forward to working with you...

$49 USD in 1 day
(59 Reviews)

9 freelancers are bidding on average $78 for this job


Such jobs are my daily practice.

$55 USD in 2 days
(48 Reviews)

Ready to start

$144 USD in 3 days
(35 Reviews)

Excel VBA Expert. Please check PM for details. Thanks.

$88 USD in 3 days
(14 Reviews)

Hello, Excel wise is here. check p.m.

$84 USD in 1 day
(7 Reviews)

Hi i can do this job for you please check pmb

$60 USD in 3 days
(5 Reviews)

Hi, I have large experience Excel and VBA macros. I can do this for you. Wait for your contact.

$88 USD in 3 days
(4 Reviews)

It can be done very quick.

$100 USD in 2 days
(0 Reviews)

Hi i have previously done these kind of jobs ..I would love to work with u..

$92 USD in 3 days
(0 Reviews)

Please read my PM

$40 USD in 1 day
(0 Reviews)

I am ready to start. Please see the pm.

$45 USD in 3 days
(0 Reviews)