Open the spreadsheet and select the “Dealer ... - Toyota



Step 1: Go to the Dealer Daily home page.

[pic]

Step 2: Select the Vehicle Management System Link

[pic]

Step 3: Find the selected the vehicle(s) to be printed from the list of vehicles in your Dealerships Inventory.

[pic]

Step 4: Use your mouse to click and drag across the vehicle data starting with “DIS” and ending at “Vehicle Invoice” to highlight the vehicle data completely in blue, click on from your browser toolbar and select . This data will be pasted into the template in the next step. Be sure to highlight and copy the entire line from DIS to Dealer Invoice.

[pic]

Step 5: Open the Excel file named Toyota Addendum Sticker Template.xls and select the “Dealer Daily Data Dump” tab and paste the copied information from Dealer Daily directly into lines

2 (vehicle #1) and 3 (vehicle #2).

*Please note: Two separate vehicles should be printed simultaneously, or one label may be wasted.

[pic]

Step 6: Select “Addendum Sticker Format” tab. Note: The highlighted cells below, showing VIN, Stock Number and vehicle price will Auto-populate after adding the Dealer Daily data to the “Dealer Daily Data Dump” Tab.

[pic]

Step 7: Starting in cell A16 (for vehicle #1) or cell G16 (for vehicle #2), select the Genuine Accessory from the Dropdown menu. The Accessory can also be typed directly into the cell. Note: Clicking on the cell will produce an arrow on the right side of the cell. Clicking this arrow will reveal the dropdown menu.

[pic]

Step 8: Once the appropriate accessory is selected, enter the accessories installed retail price in the corresponding cell in Column E. If an accessory is entered in cell A16, the price should be entered in E16.

[pic]

Repeat Steps 7 and 8 for each Genuine Accessory added to the vehicle.

*Note: Up to 7 different Genuine Accessories can be added.

Do not add lines or alter the sheet as the info will not line up with the Accesory Addendum Label.

[pic]

Step 9: Once all Genuine Accessories have been added, Aftermarket accessories can be added as well. Using the same process as Genuine Accessories, start in cell A26 (G26 for vehicle #2), and enter up to 7 aftermarket accessories including price in the corresponding cells.

[pic]

***Both the subtotal and vehicle total cells will auto-populate.

Step 10: Once both vehicles have been completed, place the appropriate Toyota or Scion addendum label sheet into the printer and print. This template has been designed to print onto the labels, so no resizing should be necessary.

[pic]

The instructions in the following pages should be used if you need to add additional Genuine Toyota or Aftermarket Accessory Descriptions to the templates drop down menus.

***To add New Accessories to either the Genuine Accessory or Aftermarket Accessory drop-down lists, select the “Drop Down List” Tab at the bottom of the spreadsheet and enter the name in the appropriate column.

[pic]

*Note: Any added accessories will be listed in the order they appear on the list. They will not be automatically alphabetized.

To Alphabetize the Accessory Lists:

Step 1: Select the data set you wish to alphabetize. Only include the cells that have accessory names.

[pic]

Step 2: Select the Data dropdown menu from the top of the screen and select the “Sort” option.

[pic]

Step 3: A sort box will appear. The 1st section says “Sort by” and should be auto-populated by the one column that has been selected. Verify the column selected matches the column with the data. Ensure that the check mark for “Ascending” is selected and click “OK”. No information needs to be entered in the 2nd or 3rd sections of the sort box.

[pic]

The selected data will now be alphabetized.

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download