Sheet 1
has 15 Rows of data ( 14 of which are hidden )

Sheet 3 has 600 Names on it

Completed sheet on sheet 1 should be:

All 600 names with each NAME getting the SET of 15 rows of data ( 14 of which will be hidden )

Rather then KEY each name and address stuff ( rows: B thru J )

How can I ?

Get each Name to get that 15 row set of data, skip a space, enter next name and give it the 15 rows of data..Until all 600 have that data?

Thank you

scott.badger@siemens.com

Record your actions and put them in a do while loop...

Regardz