Repeating Column Data

[dw7]

I have a column in Sheet 2 which can vary in size. In sheet 1 I want to have this same column of data, but I need to have the data _repeated_. So for example, it would be nice to have a formula in sheet 1 which I could drag down to say 10,000 rows which would just loop the row data that I have in sheet 2.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Any hints on how I could do this?
<o> </o>

<o> </o>
As a general side question, I was trying to do something like:
<o> </o>
=match(8,B3:B100,0)
<o> </o>
…which gives me the right row number, but if I wanted the cell to have a value of a certain other row + column.
<o> </o>
i.e.
=”g”&match(8,B3:B100,0)
<o> </o>
Would give me “G1” as the value in the cell, but what would I need to do to make the cell value = the VALUE of whatever is in cell G1? (i.e. 77.88)

 

[SteveO59L]

Try posting a sample of your data, and what you would like to do with it

 

[Andrew Poulsom]

Is it?

=INDIRECT("G"&MATCH(8,B3:B100,0))
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[dw7]

Column in Sheet 1: ......... Column in Sheet 2
8......... 8
9......... 9
4......... 4
7......... 7
8
9
4
7
8
9
4
7
8
9
4
7

 

[dw7]

Also, is there any obvious way to copy a table of data, and have the EXACT formulas copied into another location, and not changed to their relative position – without having to change to $X$# for all formulas?.