Hello,

I have a worksheet where I pull data in from ADO and currently have to manually copy it from the table that the ADO query brings in to sections for individuals below. I am wondering if there is a function in VBA that would allow me to scan rows based on a string (say firstname lastname) from the top rows to specified rows below based on a string (say firsname)? From what i have seen I can copy based on a string, but can't paste based on a string, only location.

Thanks for any help.

-Darby