Copying a column list from one sheet to another and repeating?
Thanks for your continued help with this. I will test it and let you know the
result.
"klswvu" wrote:
=OFFSET(Sheet1!$A$2,((MOD(COLUMN(),(COUNTA(Sheet1! $A$3:$A$10)-(COUNTBLANK(Sheet1!$A$3:$A$10))))=0)*(COUNTA(Sheet 1!$A$3:$A$10)-(COUNTBLANK(Sheet1!$A$3:$A$10)))+(MOD(COLUMN(),(CO UNTA(Sheet1!$A$3:$A$10)-(COUNTBLANK(Sheet1!$A$3:$A$10)))))),0)
$A$2 is the heading and anchor for the offset
$A$3:$A$10 is the range where the text is pulled from
|