Record a macro when you do it manually.

Then look at that code.

pokdbz wrote:

Sorry I wanted to do this with VBA

"Kevin B" wrote:

Open the source and target files, and in the source file right click on the
worksheet tab of the worksheet you want to copy.

In the dialog box that follows, select the destination workbook from the TO
BOOK combo box, indicate where you want the copy placed by selecting the
sheet in the BEFORE SHEET list box, click the COPY checkbox and click OK
--
Kevin Backmann


"pokdbz" wrote:

I need to copy one files worksheet and put it into another workbook and
rename the worksheet.

How can I do this?

--

Dave Peterson