Find Jobs
Hire Freelancers

MACRO_EXCEL_Altavia-Optitrans_Montage_Repartition_Transport

€1500-3000 EUR

Closed
Posted about 6 years ago

€1500-3000 EUR

Paid on delivery
Bonjour, Altavia Optitrans est la filiale transport du groupe de communication ALTAVIA, leader dans l'édition des imprimés publicitaires sans adresse distribués en boîtes-aux-lettres. Dans le cadre de ses activités, Optitrans doit préparer des fichiers excel qui permettent : 1 - aux imprimeurs de préparer les palettes par points de livraison en sortie de production, 2 - aux transporteurs de préparer leurs plans de chargement des véhicules et deviser les couts transports, 3 - à Optitrans d'envoyer les confirmations transport en EDI via son TMS. Pour cela, les équipes d'Altavia Optitrans collectent et croisent des informations provenant, sous forme de fichiers excel, de l'ERP Print d'Altavia et des fabricants en charge des dossiers. Le projet est d'automatiser, via des macros excel, toutes les opérations de : - créations de fichier, incluant des découpages et renommage de fichiers. - copier-coller de valeurs provenant de fichiers différents, recherche valeur pour faire les rapprochements, calculs simples, selection de tableau et mise en forme, synthèse sous forme de tableau croisé dynamique. - il faudra probablement prévoir un système de tableau de correspondance pour gérer les écarts de saisie (accents, majuscule, espaces qui empêchent les rapprochements). Vous trouverez, en pièces jointes, 2 fichiers excel correspondant aux fichiers avec les donneés d'entrées (noms commençant par "Fichier-Origine_xxx") + 3 fichiers excel correspondant aux fichiers de sorties (noms commençant par "Fichier-Sortie_xxx"). Bien cordialement, Jean-Luc TIREL
Project ID: 16352908

About the project

4 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average €2,787 EUR for this job
User Avatar
Hello I am Excel Expert and VBA Developer also I have been working as a Financial Auditor and I know things If interested, contact me please Thanks & Regards
€3,000 EUR in 30 days
4.9 (168 reviews)
7.0
7.0
User Avatar
Bonjour, BRD GLOBAL is #1 MULTILINGUAL Service provider on freelancer.com, our aim is to provider High Quality service to all our clients, with this in mind everything is done by Experienced Professionals. We have read your project description and can easily complete the task within your budget and deadline. Please read our reviews and chat with us to discuss your project in detail. Regards BRD GLOBAL
€2,800 EUR in 20 days
4.9 (93 reviews)
7.0
7.0
User Avatar
Hi Jean-Luc, I understand your requests and I can do the project, but the language can be a problem. Can we manage that project in English? I am a professional financial and a guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios. Also, I have experience in accounting, Financial Report Tools. I offer you 35+ years of experience working in a variety of companies including, VC's, privet investors, entrepreneurs, startups, marine and land transportation, retailers, power plants, farms, insurance, universities, real estate & constructions, medical equipment manufacturer, among others.
€2,647 EUR in 30 days
4.9 (46 reviews)
6.1
6.1

About the client

Flag of FRANCE
France
0.0
0
Member since Feb 22, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.