Using the Microsoft Excel Spreadsheet

Using the Microsoft Excel Spreadsheet

Using the Membership list from the Rotary.org website

Save the "MemberInformation" spreadsheet to your hard drive by clicking the Right Mouse Button on the "RIGHT CLICK then Click Save Target As" button above, then click Save Target As... (remember where you save this file for use later)
Please do not alter the form by removing columns and renaming the file. The only information we need for a member is the First Name, Last Name and Member Number. You can leave the other columns of information blank.
Download membership list through Rotary.org website using secretary’s password
Open the spreadsheet "MemberInformation" (the spreadsheet that you saved to your hard drive in the first step above) by double clicking the file
- Go to Data at the toolbar at the top of Excel
- Choose Get External Data and then choose Import Text File
- Go to the folder where you downloaded the text file and click the Import button (this will trigger the Text Import Wizard)
- Choose Delimited and select Next
- Click the Semicolon box, and make sure that is the only box checked.
- Click Next and then Finish
- Next you will see an Import Data dialog with the Existing Worksheet button selected. Type this into the box after the Existing Worksheet button: =Sheet1!$A$2
  It will look like this:
Click the OK and all the data should be placed on the spreadsheet in the proper place. You then need to type the member numbers into the appropriate place in the spreadsheet.
Select File and then Save from the toolbar in Excel to save the spreadsheet with all the member data.

Important:

After filling out the "MemberInformation" Excel spreadsheet, please e-mail it to Clark@ParkerSystems.com as an attachment to your e-mail. This spreadsheet is independent of the order form information and needs to be completed and sent to us separately.