hey all, is there a way to export all my worksheets in workbook to another workbook? thanks, rodchar
R rodchar Sep 6, 2007 #1 hey all, is there a way to export all my worksheets in workbook to another workbook? thanks, rodchar
D Duke Carey Sep 6, 2007 #2 One way - Right click any sheet tab and choose "Select All", then right click the tab again and choose "Move or Copy..." and follow the prompts Another way - File-> Save as
One way - Right click any sheet tab and choose "Select All", then right click the tab again and choose "Move or Copy..." and follow the prompts Another way - File-> Save as
G Gord Dibben Sep 6, 2007 #3 If a one-time deal just have both workbooks open. Select all the sheets from source book and "move or copy" to the target book. If doing this often, turn on the macro recorder to create a macro. Gord Dibben MS Excel MVP
If a one-time deal just have both workbooks open. Select all the sheets from source book and "move or copy" to the target book. If doing this often, turn on the macro recorder to create a macro. Gord Dibben MS Excel MVP
