copy worksheet to another workbook
 

Each month I create a new folder with a workbook to enter daily activity. At
the end of the month, I run a macro that creates a summary page of all of the
data. I would like to link or copy the summary page to another workbook in
the same folder. What code could I add to accomplish this.?

copy worksheet to another workbook
 

Do you expect that you'll have any cells in the worksheet that might not be
copied (long data entry). If so, copying the worksheet might not work
without doing other things. If it were me, I'd save the file with a new name
and then delete all the worksheets but the one you need.

Do you want to keep the summary page with the original workbook? Or can it
be created as a separate workbook?

There are several approaches that can be taken.

Let us know.
Barb Reinhardt

"marcia2026" wrote:

Each month I create a new folder with a workbook to enter daily activity. At
the end of the month, I run a macro that creates a summary page of all of the
data. I would like to link or copy the summary page to another workbook in
the same folder. What code could I add to accomplish this.?

copy worksheet to another workbook
 

Maybe you can find something useful he
http://www.rondebruin.nl/summary.htm
http://www.rondebruin.nl/summary2.htm
and finally...
http://msdn.microsoft.com/en-us/library/cc793964.aspx

Regards,
Ryan---

--
RyGuy


"Barb Reinhardt" wrote:

Do you expect that you'll have any cells in the worksheet that might not be
copied (long data entry). If so, copying the worksheet might not work
without doing other things. If it were me, I'd save the file with a new name
and then delete all the worksheets but the one you need.

Do you want to keep the summary page with the original workbook? Or can it
be created as a separate workbook?

There are several approaches that can be taken.

Let us know.
Barb Reinhardt

"marcia2026" wrote:

Each month I create a new folder with a workbook to enter daily activity. At
the end of the month, I run a macro that creates a summary page of all of the
data. I would like to link or copy the summary page to another workbook in
the same folder. What code could I add to accomplish this.?

copy worksheet to another workbook
 

It does not matter if the summary sheet stays in the original workbook or
not. The macro can create it at any time. However, I do need to get the
information into the "NSF" workbook in order to manipulate the data with
other information.

"Barb Reinhardt" wrote:

Do you expect that you'll have any cells in the worksheet that might not be
copied (long data entry). If so, copying the worksheet might not work
without doing other things. If it were me, I'd save the file with a new name
and then delete all the worksheets but the one you need.

Do you want to keep the summary page with the original workbook? Or can it
be created as a separate workbook?

There are several approaches that can be taken.

Let us know.
Barb Reinhardt

"marcia2026" wrote:

Each month I create a new folder with a workbook to enter daily activity. At
the end of the month, I run a macro that creates a summary page of all of the
data. I would like to link or copy the summary page to another workbook in
the same folder. What code could I add to accomplish this.?

copy worksheet to another workbook
 

Ok, here it is in a nutshell. At a certain point in my macro, I need to open
a workbook (of my choosing), copy the summary page (always named "Summary) to
the active workbook, then close the 2nd workbook that I opened. Then move on
in my macro.

I don't have a clue how to do this. I have searched the forum and all of
the links that have been provided and nothing makes sense to me on this one.



"marcia2026" wrote:

It does not matter if the summary sheet stays in the original workbook or
not. The macro can create it at any time. However, I do need to get the
information into the "NSF" workbook in order to manipulate the data with
other information.

"Barb Reinhardt" wrote:

Do you expect that you'll have any cells in the worksheet that might not be
copied (long data entry). If so, copying the worksheet might not work
without doing other things. If it were me, I'd save the file with a new name
and then delete all the worksheets but the one you need.

Do you want to keep the summary page with the original workbook? Or can it
be created as a separate workbook?

There are several approaches that can be taken.

Let us know.
Barb Reinhardt

"marcia2026" wrote:

Each month I create a new folder with a workbook to enter daily activity. At
the end of the month, I run a macro that creates a summary page of all of the
data. I would like to link or copy the summary page to another workbook in
the same folder. What code could I add to accomplish this.?