Find and Open Workbook then copy and move sheet

Hi all,

I hope this all makes some sense.

I have a template that compiles financial information from various other
workbooks. I want the user to be able open a workbook and then either enter
a worksheet name or select a worksheet and have the worksheet copied into the
template.

I figured out how to get a file open with Application.FindFile, but as for
selecting a specific sheet and getting from the newly opened workbook to the
template, I am lost.

Any help is greatly appreciated.

cwilson

You should try to record your macro first, then if it doesn't behave as required post the problem again, with the code you created.

Cheers