| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move worksheet to end of another workbook
Hi,
I'm using Excel 2010 and have two spreadsheets that I want to merge. One of these is my timesheet workbook (called "breakdown 2013.xlsx") and the other is my daily time. I have managed to create a macro that will mostly do what I want, but I cannot find the code to get the daily sheet to insert at the end of the "breakdown" without having to constantly change the number of sheets. The code I'm using is : ActiveSheet.Select ActiveSheet.Move after:=Workbooks("breakdown 2013.xlsx").Sheets(135) Can anyone assist with this - it's irking me no end. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move a worksheet from one workbook to another | Excel Discussion (Misc queries) | |||
| Move to a named worksheet from any worksheet in the same workbook | Excel Programming | |||
| Why can't you just Move a worksheet in Excel '07 to new workbook? | Excel Worksheet Functions | |||
| Move worksheet within workbook | Excel Programming | |||
| MOVE Worksheet to another workbook ? | Excel Programming | |||
Threaded Mode
