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.
Contact Spreadsheet Automation
- New contact sheet with functionality as below
- Organise and update new entries
- Ease of data maintenance
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.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.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