Managing Amazon Roster: Uploading, Filtering, Deleting, and Re-uploading

Click on the Column of the day to upload. In this case, it would be Column H for Friday, 1/26
​EXCEL:

​Google Sheets:

Click on Sort & Filter
​EXCEL:

​Google Sheets:

Click on Filter
​EXCEL:

​Google Sheets: See the next step
​

Click the New Filter for Column H
​EXCEL:

​Google Sheets:

Uncheck Select All
​EXCEL:

​Google Sheets: Click on Clear to unselect all.

Check (Blanks)
​EXCEL:

​Google Sheets:

Click on Apply
​EXCEL:

​Google Sheets: Click on OK

Column H is empty, meaning the Associate is NOT rostered. Click & Hold on Row Number (6) of the first Associate (Oscar Flores), and drag to the bottom of the list to highlight ALL rows.
​EXCEL:

​Google Sheets:

When you are at the bottom of the list, unselect after the last Associate, Zapp Branigan, Row 150.
​EXCEL:

​Google Sheets:

Click on Delete
​EXCEL:

​Google Sheets: Under the file name click Edit, Delete, and Selected Rows

You'll notice ALL Associates not working are deleted.
​EXCEL:

​Google Sheets:

Click on the filter for Column H
​EXCEL:

​Google Sheets:

Check 'Select All'
​EXCEL:

​Google Sheets: Click on Select all

Click on Apply
​EXCEL:

​Google Sheets: Click OK

All the Associates working are listed.
​EXCEL:

​
​Google Sheets:

Save your file and re-upload it into Hera.
​EXCEL:

​Google Sheets: Below the file name click File, Download, Microsoft Excel (.xlsx)