|Here are some instruction on converting the DataValFlexList.xls|
to somthing you could use.
It's mostly just Cut & Paste with a bit of editing formulas.
Open a new workbook
Open the DataValFlexList.xls
In the DataValFlexList.xls, select columns A, B, C, & D
Go to your new work book and Paste to column A
You should now have new columns A, B, C, & D from
Next, in your new workbook, select Column D,
which is the User Input column and Cut
next, select Column A and Paste.
Next, select Column B,
which is the List Items column and Cut
next, select Column D and Paste.
Select cell A1 and change the heading to: Sport
Select cell B1 and input the heading: Players
Select cell D1 and change the heading to: Sport List
Select cell E2 and input Totals
In cell E3 enter the formula:
NOTE: you will need to modify this if you go beyond 100 rows
in column A
Now we need to change at least one of the Named Ranges:
In 2003, on the tool bar select Insert, Select Name, Define
There should be two Named Ranges:
First look at the named range: rngUserInput
in the Refers To box at the bottom, it should show: =Sheet1!$A$2:$A$20
if it does not show that, change it.
Next look at the named range: LU_FlexibleList
in the Refers To box at the bottom, were going to delete the current formula
and insert this formula:
Click Close and were done.
Now, hopefully, when you enter a Sport in Column A
and the number of players in Column B
Column D will show the sport, and column E the total number