Is it just me or is your value doesn't make any sense?

if value is 1, paste Sheet1(A1:A5) to Sheet2(D1:D5)
if value is 54, Past Sheet1(A1:A5) to Sheet2(D10:D15)

How does 1 relate to D1:D5 and 54 relate to D10:D15?

and A1:A5 is a range of 5 cells, D10:D15 is a range of 6 cells...


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=549722