darby
09-28-2023, 02:47 PM
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
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