Inserting an existing worksheet into a workbook

[coposg]

Hi all,

I have a Excel worksheet I use to calculate information in a daily spreadsheet received from a supplier; does anyone have any suggestions on how I can insert the existing worksheet into a new workbook? Hope I've explained properly - I have sheet TEMPLATE I want to insert into workbook TODAYS DATE, but would prefer I could insert the sheet automatically if possible, rather than via any commands in the Insert menu option.

Thanks
Steven

 

[xlbo]

right click the sheet you want to move
Select "Move or Copy"
Choose the workbook you wish to move it to and where you wish to place it
et voila

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[JerryKlmns]

coposg,

This

Workbooks(1).Worksheets("Sheet1").Copy

creates a new workbook and inserts Sheet1 of currently open workbook(1)

 

[coposg]

Thanks for the feedback Geoff and Jerry, I was hoping it could be automated between two existing workbooks but if I can do it one of those two ways, that is sufficient.

 

[JerryKlmns]

coposg,

If you need to copy sheet1 of workbook1 to workbook2 (an opened existing file), then

Workbooks(1).Worksheets("Sheet1").Copy,
Workbooks(2).Worksheets(1)

to place it before the first worksheet of workbook2 or,

Workbooks(1).Worksheets("Sheet1").Copy, ,
Workbooks(2).Worksheets(1)

to place it after the first worksheet of workbook2