Admin Assistant

Cross-Reference Admin Assistant

Tattoo Convention Banner Print Preparation

We are looking for a detail-oriented assistant to help organize banner files for tattoo artists attending upcoming conventions.

The task involves cross-referencing artist names in a spreadsheet with banner design files, organizing the correct files into a print folder, and updating the spreadsheet accordingly.

Project Overview
• Total banner files available: ~400
• Banners that need to be located and prepared for print: ~250
• A spreadsheet with artist names already exists

Responsibilities
1. Review the existing spreadsheet of artists who have paid for banners.
2. Locate the matching banner file inside a master folder containing approximately 400 banner files.
3. When a matching banner is found:
• Move the banner file into a “PRINT” folder
• Mark the artist in the spreadsheet as DONE
4. If the banner cannot be found:
• Mark the spreadsheet as BANNER NOT FOUND
5. Ensure file names match the artist name listed in the spreadsheet.

Final Deliverables

At the end of the project you will provide:
• A folder containing all banners ready for printing (~250 files)
• The updated spreadsheet with:
• Completed banners marked DONE
• Missing banners marked BANNER NOT FOUND

Requirements
• Strong attention to detail
• Ability to carefully match names between files and spreadsheets
• Comfortable working with Google Drive / Dropbox / standard file folders
• Basic spreadsheet knowledge (Excel or Google Sheets)

Project Scope
• One-time project
• Approximately 250 banners need to be located
• Estimated 1–3 hours of work

Accuracy is very important because the final folder will be sent directly to the printing company.