Find Jobs
Hire Freelancers

AppleScript Programmer needed for Excel Contact Database

$250-750 AUD

In Progress
Posted over 12 years ago

$250-750 AUD

Paid on delivery
Hi there... I sourced a programmer to create an automated spreadsheet for international contacts, with spec for operation in Excel for Mac - project was delivered in Windows and now I'm stuck with something I can't use within my company (who all use Mac). I need someone to either reprogram with AppleScript from the excel macro + spreadsheet I have here, or start from scratch. Brief below: Contact Spreadsheet Automation This includes: - New contact sheet with functionality as below - Organise and update new entries - Ease of data maintenance - AppleScript Script flow: 1. 1.1 - An entry form sheet ('NEW CONTACT') which has fields for entry & drop-down lists of pre-optioned entry ('CATEGORY', 'TERRITORY', 'ENTERED BY') 1.2 – Auto format of entry to the same font / font size / colour etc 1.2 – 'SUBMIT' button which orders & sorts the information into it's relevant TERRITORY sheet ('USA', 'UK', 'Japan', etc.) 2. 2.1 – When the new info is sent to it's corresponding TERRITORY sheet, each entry defaults & auto sorted first by CATEGORY, then alphabetically. 2.2 – Enable functionality of certain column headings ( 'CATEGORY', 'COMPANY', 'ROLE', CITY', 'STATE' & 'Dew Process Contact') to auto sort by that category. 2.3 – When sorted by the column headings above, each group of entries should have a heading (see attached 2 screenshots of my mockup example – the grey headings for each group). 3. 3.1 – I need to be able to make additions / amendments to the fields, easily 3.2 - Support for coping in large pre-existing & formated contact sheets
Project ID: 1126955

About the project

1 proposal
Remote project
Active 13 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
Awarded to:
User Avatar
See PMB for details please..
$300 AUD in 3 days
5.0 (64 reviews)
5.3
5.3

About the client

Flag of AUSTRALIA
Sydney, Australia
0.0
0
Member since Jul 12, 2011

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.