In Progress

AppleScript Programmer needed for Excel Contact Database

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

Skills: Excel, Mac OS

See more: create database applescript, excel contact, applescript database, windows programmer, script sheets, programmer uk, programmer info, programmer spreadsheet, pre flow, support role, grey group, fields auto group, excel support company, contact programmer, excel spreadsheet programmer, auto programmer, sort excel, macro excel, m international, need programmer contact form, format excel, excel programmer needed, dew, create operation, coping

About the Employer:
( 0 reviews ) Sydney, Australia

Project ID: #1126955

Awarded to:

mrbrave

See PMB for details please..

$300 AUD in 3 days
(64 Reviews)
5.3