You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"emm" wrote in message
...
Thanks for your reply, it worked!

"T. Valko" wrote:

Here's a non-volatile approach...

Assume your data on Sheet1 is in the range A2:A10

You want the results to appear on Sheet2 starting in cell A2.

Enter this formula on Sheet2 cell A2 and copy down as needed:

=INDEX(Sheet1!A$2:A$10,CEILING(ROWS(A$2:A2)/3,1))

--
Biff
Microsoft Excel MVP


"emm" wrote in message
...
I need a formula on one sheet to reflect a number in another sheet.
That
number must be repeated 3 times, then the formula needs to go to the
next
row
and return the new number.
Sheet 1: 12345
12352
Sheet 2: an example of the outcome I need...
12345
12345
12345
12352
12352
12352