Copy/Move multiple WorkSheets

  • Thread starter Thread starter ten
  • Start date Start date
T

ten

Hi,
I have several Excel Spreadsheets, all containing about
20 worksheets. I want to collect all Worksheet in one
Spreadsheat. I know I can use to Move or copy-function
for one and one sheet, but that is a really time-
consuming afair. When I try to select more than one sheet
and move it at the sam etime, I only get name-errors.

Do anybody have a godd solution for moving many sheets at
once? Thanks!
 
Dear ten
At first ,select all,then Copy/Move them to another


Curllion
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
I want to undo 'move or copy worksheet' 1
Worksheet + 1 1
move a row of data from one work sheet to another using a formula 1
Too Few Rows to copy sheet to another book 2
How To Stop Excel Copying Named Functions When A Worksheet Is Copied? 2
Can not copy or move some worksheet 1
Excel 2007 Move or Copy worksheet 2

Back
Top