copy row

[Sharp]

Hi,

the code below asks a user for a name and then searchs the sheet for the name and deletes every row that name appears on. Does anyone know how to modify this code so that rather than delete the row it copys it to another sheet

thanks

[davesexcel]

I am not sure how this will work in the loop but this will copy and paste to the next empty cell in column A sheet2

Please Login or Register  to view this content.