offset code

[ccarruth]

Needing non-VBA formula to copy a series of values, with each value repeating a set number of times, before the next value in the series is pulled and repeated, then the next, etc. The series value is copied to the new location based on the presence of an "X" in another part of the worksheet, with the series starting in the same column, different row, as the "X". The X can appear in any column and can move from one column to another. File attached. Thanks!

 

[Somendra Misra]

Hi,

See the file.

Regards,

 

[Somendra Misra]

See this also non-array formula solution a bit simpler.

Regards,

 

[John Jairo V]

Hi @ccarruth (and @Somendra Misra)

I leave another option... controling both sides. I'm glad to sharing post with you @Somendra Misra ! Blessings!

 

[Somendra Misra]

@John Jairo V

Thanks for your kind words. Me to glad to have another solution of the same problem.

Regards,