Thats beautiful Debra. Thank You. Thank you also trevor, but it looks like
what you wrote was vbase and I have no idea where I would even enter that
stuff or how to run it, etc.

Thanks\\

Debra Dalgleish wrote:
On Sheet 1, in cell A2, enter the formula:

=INDEX(Sheet2!$A$1:$A$20,MATCH(ROW(),Sheet2!$B$1:$ B$20,1))

Copy down to row 1000

Hello,

[quoted text clipped - 14 lines]
Thanks in advance,
Derek



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1