worksheet export

termeric

Board Regular
Joined
Jun 21, 2005
Messages
245
hello,

im trying to create a macro that will take the worksheet out of the workbook, and copy it to a new workbook.

i have a workbook where i enter info into the first worksheet and then it is used to fillin redundant information on the next 7 or 8 worksheets. from there, i have to copy the worksheet to a new workbook and send it out.

can any one help me out with this?

also, is it possible to drag over more than one work sheet?


thanks,

christian
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
Try playing with this:
Sheets("Sheet4").Copy Before:=Workbooks("TestFile.xls").Sheets(1)
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,048
Office Version
  1. 365
Platform
  1. Windows
Christian

You can easily copy a worksheet to a new workbook like this.
Code:
ActiveSheet.Copy
This will create a new workbook with only the ActiveSheet in it.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,234
Messages
5,571,042
Members
412,358
Latest member
Eng Muhammed
Top