Appending Worksheets

[Eric]

Good Morning.
I need to append several worksheets to the bottom of a
worksheet and I'm not sure how I can do this easily. We
have 20 worksheets each week, some in different spread
sheets and some in the same worksheet that need to be
appended to the bottom of 1 of the worksheets. Manually
doing a copy and paste takes some time. All the fields
are the same so they should drop in easily.

Thanks

 

[Don Guillett]

1st. we need to determine then meaning of IS, Bill

worksheet=part of a workbook
workbook=a file with worksheets in it
spreadsheet=???? old terminology

 

[Guest]

Bill: I'm not sure what you mean by "IS".
What I want to do is merge 20 worksheets into 1.

Thanks
Eric

 

[Don Guillett]

It's from the Bill Clinton "problem"
You still haven't told us where the worksheets are.
Are they in the same workbook and you want to merge sheets 2-22 into sheet
1, appending to the end?
What are the ranges?
This can be accomplished with a for/each loop

 

[Eric]

Got it.
1 comes from within the same workbook and the others are
from separate files. The combination of all the files
will be in the 1st worksheet.
How do you append from within the same workbook and how do
you append from another workbook. The file names should
remain the same week to week.

Thanks