Import Text to specific cell

[AEngineerDU]

I'd like to import a set of data to specific, non-sequential, cells in
a spreadsheet. Is there a way of doing this without using VBA?

e.g. 3 fields worth per row of source data with the first being Column
and the second being row and third being the text (or number) to put in
a cell.

Data:
A 3 "3.5 Course1"
C 5 " 3 Course 3"
etc.

This would put "3.5 Course1" in cell A:3, " 3 Course 3" in C:5 etc.

It seems as though it ought to be doable. Any help would be
appreciated.

Jim Mitchell

 

[Owen]

I don't think you can without VBA

Assuming your data starts in a1:c(n) without blanks this should do what
you're looking for.

HTHs
*******

Sub DistributeData()

Dim i As Long
Dim strCell As String

Do
If Range("A1").Offset(i, 0) <> "" Then
strCell = Range("A1").Offset(i, 0) & Range("A1").Offset(i, 1)
Range(strCell) = Range("A1").Offset(i, 2)
End If
i = i + 1
Loop Until Range("A1").Offset(i, 0) = ""


End Sub