Hi Marling Imaging,
The following steps will help you update the Sales Rep dropdown for the leads:
1. Go to Customize>Integration Tools
2. Click on the Go to Import/Export... link within the Import/Export section within the page
3. In Step 1:Import/Export
a) Select Export a table to a file
b) Select the Customer table from the dropdown
c) In step 3, click the button Deselect All and then check the field RecordID. FullName, IsLeadStatusOnly, and SalesRep
d) In step 4, select the format of Comma-Separated Values
e) Click on the Export to File... button
4. In Step 1: Import/Export
a) Select Import into a table from a file
b) Select the Customer table from the dropdown
c) Click on the Choose File button and select the file that you just exported
d) Click on the Import Data… button
5. In the Import – Step 2: Prepare Data screen
a) Checkmark Update existing records by matching the key fields checkbox and make sure RecordID is checked off.
b) In the section to select the columns to import, make sure that you select Do Not Import for the “FullName” field, Do Not Import for the IsLeadStatusOnly field, To Existing Field for the RecordID field, and To Existing Field for the SalesRep field
Click on the Import Data button
6. In the Import – Step 3: Validation screen
Click on the Begin Import button and then the Finish button.
I hope that this helps.
Ronen