It's nice to meet you,

My name is Bill Rudd, I'm new to VBA but would like to finish my first project.

I would like to call up a find box, then be able to search several worksheets for a string, to copy and paste the related row to a new worksheet.

I've gotten as far as being able to search for a string and get the row pasted, as long as the string is defined in my macro. Is there a way though to be able to call up a find box first though, and search for the input variable? (alternatively, I can only imagine a separate piece of code for each variable, of which there are many, and I am actually trying to save time... )

Is there someone that can point me in the right direction, I would be very obliged.

Yours Truly,
Bill