- First, you must receive the email which gets sent every morning at 5 am from Support (Subject: Travel Quest IC Data Export)
- Open the file and sort the issue date by oldest to newest (column A)
- Now go to the AutoSupplier Email Excel and look to see what was the last date in column A.
- Whatever the last date was, we are going to pull data for one date prior. (if the last date was the 10th, we are going to pull starting from the 9th)
- Take the desired date from the AutoSupplier Email Excel and find it on the IC Data Export email.
- Copy columns A-H and all the rows below the starting date
- Paste the data into the Auto Supplier Excel at the correct starting point (Only columns A-H will be full)
- Next, drag the columns I-L to the end of the sheet. This will copy the sheet.
