You would need to create a userform where the user can enter the data in
one go, after which the entered data could be highlighted and a message
box that the user can either click yes or no to continue, you also need
to make sure that your named ranges are dynamic otherwise they will not
expand or contract with the insertion or removal of data.


--
Breakfast Guy

Regards,
Breakfast Guy
Forum Moderator
www.thecodecage.com
------------------------------------------------------------------------
Breakfast Guy's Profile: http://www.thecodecage.com/forumz/member.php?userid=5
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=7252