In Progress

Macro/ import export data to and from excel spreadsheet.

This project has the aim to create a macro or similar code to produce a manifest for drivers in an excel spreadsheet format that can be shared or downloaded. I am open to suggestions, if this process can be done in any other way, but a macro of sort seems the quickest and most cost effective. Here are some of the steps we need to complete:

1. Down load the manifest.

2. Manipulate the columns in the spreadsheet, about 3 steps here.

3. Export the date to [url removed, login to view] to do some optimization , 3 steps here.

4. Import data back into a spreadsheet and share so that it can be printed at other locations.

5. This is what csv file will look like.

TW1 2PF D Standard Parcel j Jones Flat 4 1 Cambridge Park 0208 555 555 LIND 86-006-78-59241717-1

TW1 2QB D Standard Parcel j Jones 11 Old House Gardens Park Road 209 555 555 LIND 86-006-78-59241727-0

TW1 4HX D Standard Parcel j Jones 15 GROVE AVENUE 210 555 555 TRU2 POD 86-006-78-40526988-1

TW10 7AA D Standard Parcel j Jones Petersham Farm Stables 211 555 555 LAKE 86-006-78-79366207-3

6. This is what the final excel spreadsheet looks like (see uploaded file)

Total collections: TICK=CUSTOMER SIGNED,P=PORCH, M=MISSING, C/F=CARRY FORWARD,

Total deliveries: ENTER HOUSE NUMBER IF DELIVERING TO NEIGHBOUR.

Total for the day: ALWAYS RECORD BARCODE FOR UNMANIFESTED PARCELS AND COLLECTIONS.

Order In kt130uz Delivered Collected Code Print Sign

1 TW12 2HW 15 PERCY ROAD MRS j Jones 077763660459 RED 86-006-78-15235923-1 Standard Parcel D/S

2 TW12 2QA 4 Priory Close John slater 0791 478586 KIDC POD 86-006-78-37755838-9 Standard Parcel D

Skills: PHP, Software Architecture

See more: php to excel export, m format in excel, d 555

About the Employer:
( 15 reviews ) Isleworth, United Kingdom

Project ID: #9636154

Awarded to:

tecnosein

Dear Sir or Madam: We do all kinds of professional works in internet, Data entry/input, processing, Excel, Web Search, emails/phone, etc Also, we do professional computer programming and design work with: PHP, More

$120 USD in 2 days
(1 Review)
0.0

10 freelancers are bidding on average $150 for this job

jcsconsulting

I have spent some time looking at the documentation you provided. Here are my thoughts. I reviewed the Optimap site and it looks like the system uses JavaScript which is not ideal for traditional web scraping. Woul More

$170 USD in 7 days
(16 Reviews)
5.2
MladenMaslic

Hello my friend. I am automation expert. I am very interested for your project. I would like to make you demo version first (for free). SO you can try it. And if you like how its look\work. Then you can accept my bid a More

$250 USD in 4 days
(25 Reviews)
4.6
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 55+ are complex VB/VBA projects, hence i can definitely deliv More

$105 USD in 3 days
(10 Reviews)
4.0
kjgroup197318

------------Nice [url removed, login to view] result in time.------------- Hello.Sir. I am very interesing for your project because I am high program developer. If you want to know about me, you can see my profile. If you will award m More

$157 USD in 3 days
(7 Reviews)
4.6
coures

Hi! I have a 5 year working experience with php and ruby on rails, including Laravel My Technical skills are: PHP - Yii, Laravel, Symfony, Zend Javascript - Node.js , AngularJS, Knockout.js , Ember.js , Leafl More

$250 USD in 3 days
(5 Reviews)
3.6
mderevyanchuk

A proposal has not yet been provided

$77 USD in 2 days
(6 Reviews)
3.0
codrutpredoi

Hey there. I have experience in creating macros for the office suite and I have also experience manipulating csv files and creating custom sheets in excel, mostly for statistics.

$100 USD in 3 days
(3 Reviews)
2.2
$100 USD in 3 days
(2 Reviews)
1.1
khurramAnsar26

I have excellent skills in web development, PHP and sql etc. I have done project Data base engineering and have score of 3.6 CGPA out 4. I do my work with full dedication and also in given time. Thank you

$80 USD in 10 days
(0 Reviews)
0.0
joycemorelli

Hi, How are you? I am Business Administrator and I use work with Excell and numbers all day. I can easily do this job for you. I am a very reliable person and I always deliver work on time. You also can view More

$250 USD in 3 days
(0 Reviews)
0.0