This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:add_chargebacks_sheet [2025/06/22 13:27] 20.171.207.43 old revision restored (2025/05/22 05:55) |
admin:add_chargebacks_sheet [2025/06/22 13:52] (current) 20.171.207.43 old revision restored (2025/06/22 13:28) |
||
---|---|---|---|
Line 26: | Line 26: | ||
7. Open the file in Excel. You will need to expand the Post Date and Trans Date columns to prevent the values ` from appearing as ######. | 7. Open the file in Excel. You will need to expand the Post Date and Trans Date columns to prevent the values ` from appearing as ######. | ||
- | + | 8. Select the Chargeback ID column (column A) and click Sort & Filter > Sort Smallest to Largest. | |
- | 8. Select the Chargeback ID column (column A) and click Sort & Filter > Sort Smallest to Largest. | + | |
- | + | ||
9. Match the last Chargeback ID from the CB Tracker sheet to the record in Excel. Delete that row and prior ones so we are only left with the new records. | 9. Match the last Chargeback ID from the CB Tracker sheet to the record in Excel. Delete that row and prior ones so we are only left with the new records. | ||