I'm trying to write a macro that copies cell B13 from the worksheet 1 (Template 1) and then find that value in Column C:C on worksheets 2 (Import Template). When I use the macro recorder, it hard-codes the copied cell in the "find" box. Since my value in B13 will change, my existing macro will not work for me.

Any ideas?

Thanks,
Steve