# Repeating Column Data

#### dw7

##### New Member
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)

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Try posting a sample of your data, and what you would like to do with it

Is it?

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

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

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?.

Replies
4
Views
187
Replies
0
Views
352
Replies
1
Views
681
Replies
1
Views
256
Replies
16
Views
598

1,203,145
Messages
6,053,750
Members
444,681
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back