| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Worksheets in Another Workbook
I need to be able to have worksheets from multiple workbooks copied
and then pasted to the end of another workbook. I have the code set so that the user can type in the file they would like to open for everything to be pasted to but I dont know how to have worksheets from separate workbooks pasted in. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Worksheets in Another Workbook
Record a new macro while going through the process of copying a sheet or two
from one workbook into another, then examine that code. You'll need to set up variables to hold the names of the workbooks. You can paste to the end of the other workbook by using the After:= parameter and the Worksheets.Count property of that workbook. The macro is going to show you something like After:=Sheets(3) where 3 is the number of the sheets in the workbook before the copy was done. You could use After:=Sheets(Sheets.Count) to make that a variable and always copy the new sheets to the end of that workbook. " wrote: I need to be able to have worksheets from multiple workbooks copied and then pasted to the end of another workbook. I have the code set so that the user can type in the file they would like to open for everything to be pasted to but I dont know how to have worksheets from separate workbooks pasted in. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Worksheets in Another Workbook
Works for me
"JLatham" wrote: Record a new macro while going through the process of copying a sheet or two from one workbook into another, then examine that code. You'll need to set up variables to hold the names of the workbooks. You can paste to the end of the other workbook by using the After:= parameter and the Worksheets.Count property of that workbook. The macro is going to show you something like After:=Sheets(3) where 3 is the number of the sheets in the workbook before the copy was done. You could use After:=Sheets(Sheets.Count) to make that a variable and always copy the new sheets to the end of that workbook. " wrote: I need to be able to have worksheets from multiple workbooks copied and then pasted to the end of another workbook. I have the code set so that the user can type in the file they would like to open for everything to be pasted to but I dont know how to have worksheets from separate workbooks pasted in. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste Link Worksheets | Excel Discussion (Misc queries) | |||
| paste to several worksheets | Excel Discussion (Misc queries) | |||
| copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
| Copy and Paste between 2 worksheets with VBA | Excel Worksheet Functions | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Hybrid Mode
