Copy/Paste Loop
 

Hello all,

I'm new at this and am having difficulties creating a complex macro.

The model allows the user to select from a large list in sheet CPR. From
there, several cells will auto populate from a database in sheet L. My
problem is, that depending on the selection, anywhere from 1-10 cells may
populate. Also, I only want information from one of the several criteria
("subrecords") in the database.

The database in Sheet L has an advance filter which pulls up all records
with the selection from CPR. Column F contains several types of entries. I
would like to find all of the "IT"'s in column F and copy the cell to the
right of it. Then move back to CPR and paste in a particular cell. Then I
need it to find the next "IT" in column F, copy the cell to the right, move
back to CPR and paste in the cell below the prior cell. And so on until all
"IT"'s have been found and their adjacent cell copied.

I tried recording a macro, but I couldn't get the loop to work. I then
tried modifying it manually to no avail. I can't even get the Find object
working, so any help is greatly appreciated.

Thanks
Jelly's