Hey Lui,

With an in-line verification as you want, it will be impossible to do
what you want. BUT, if you set up a pop-up (userform) box when you
click the add button you already have, you can have a combobox linked
back to the source data on the one sheet. Then with a Select Case
statement, you can tell the system how many times you want it to create
each line for each "case". Or. You can use a general reference select
case statement and have it refer back to the number of lines for each
type on the sheet containing the source data. This way if you have a
lot of data, your not writing a bunch of source code. I think I know
what you want to do. If this sounds about right, let me know and I
will look into helping you write the code.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=513851