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

Please provide the file to the winning freelancer. Removed by the Admin.

Skills: Excel, Mac OS

See more: create database applescript, excel contact, applescript database, windows programmer, script sheets, programmer uk, programmer info, programmer for spreadsheet, pre flow, need of excel programmer, need a programmer uk, m.s. international, m format in excel, it support role, grey group, fields auto group, excel support company, create excel form for data entry, create data entry form in excel, contact a programmer, it programmer needed, excel spreadsheet programmer, auto programmer, sort excel, programmer needed

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