Maybe Arrays will Work

[Sincity_Jason]

Is there a function that will look at a cell(A1) with a value (10), and return the contents of another cell from another sheet as many times as the value in cell (A1) = 10 or 10 times down a column.

 

[PaddyD]

You could do it with a formula if:

a) there was a maximum value to the number in cell A1
b) you knew what it was

but I guess VBA's the way to go!

Paddy

 

[Sincity_Jason]

The Value in A1, is actually refers to a Lot# could be any kind of Number Mayber even a Alpha... I will know what that value is, i will enter it along with succesive others in sequence.. then need to copy each one to another column as many times as the other cell states...