techissue2008
Board Regular
- Joined
- Jun 13, 2008
- Messages
- 80
Hi
I use Excel 2002.
Spreadsheet 1 : Data source
Column One : Score
97:98
87:79
How can I get score data from column One 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
Sub splitdata()
Sheets("Sheet2").Cells.ClearContents
Sheets("Sheet2").Range("A").Value = Sheets("Sheet1").Range("A").Value
End Sub
It will show
0.041666667
0.001388889
I use Excel 2002.
Spreadsheet 1 : Data source
Column One : Score
97:98
87:79
How can I get score data from column One 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
Sub splitdata()
Sheets("Sheet2").Cells.ClearContents
Sheets("Sheet2").Range("A").Value = Sheets("Sheet1").Range("A").Value
End Sub
It will show
0.041666667
0.001388889