Hi

I use Excel 2002.

Spreadsheet 1 : Data source
Column One : 1st Basketball Team
Rockets
Kings

Column Two : 2nd Basketball Team
Orlando Magic
Bulls

Column Three : Score
97:98
87:79

They means (1st row) Rockets vs Orlando Magic (97:98), (2nd row) Kings vs Bulls (87:79)

How can I create the following spreadsheets using VBA?

---------------------------------------------------------------------
Spreadsheet 2 : Auto-retrieve data from Spreadsheet 1

Get basketball team data from column one and column two of spreadsheet 1, put them into one column in spreadsheet 2.

Column one (Sorted by alphabetic order and non-duplicated)
Bulls
Kings
Rockets
Orlando Magic

----------------------------------------------------------------------
Spreadsheet 3 : Auto-retrieve data from spreadsheet 1

Get score data from column three of spreadsheet 1

Split the data 97:98 into 97 and 98 of spreadsheet 1, put them into 2 columns of spreadsheet 2

Column one
97
87

Column two
98
79

-----------------------------------------------------------------------
Spreadsheet 4 : Auto-create a table according to the number of teams. indicate a color of cell according to the score result.

For example, there are 4 teams, the total numbers of round is 2.

Rockets vs Orlando Magic 97:98 round #1
Kings vs Bulls 87:79 round #1

Rockets vs Bulls 90:90 round #2
Kings vs Orlando Magic 91:89 round #2

Column 1 Column 2
Team name Round #1
Rockets Cell changes to Blue color if Rockets lose (97:98)
Orlando Magic Cell changes to Green color if OM won (97:98)
Kings Cell changes to Green color if Kings won (87:79)
Bulls Cell changes to Blue color if Bulls loss (87:79)

Column 1 Column 3
Team name Round #2
Rockets Cell changes to White color if Rockets equals (90:90)
Bulls Cell changes to White color if Bulls equals (90:90)
Kings Cell changes to Green color if Kings won (91:89)
Orlando Magic Cell changes to Green color if OM won (91:89)

Thanks for advice