What is it that you have in Cell I4 in Sheet 2?
How does it scroll through the data in A2:A77 in Sheet1
When you say 'name define', what do you mean?

The data in cell I4 in sheet 2 uses the name define( see
insert/name/define) to scroll through a range of cells in the first
sheet, which are currently A2 through A77, and pick the data rather
than typing it in.

Thanks
cjl


--
CJL
------------------------------------------------------------------------
CJL's Profile: http://www.excelforum.com/member.php...o&userid=24118
View this thread: http://www.excelforum.com/showthread...hreadid=377459