How to automatically combine several worksheets into on ene worksheet

J

John Keith

I'm looking for tips on how to how to automate a task I frequently do.

Here's the scenario:

I want to open a spreadsheet and when that sheet opens I want it to
read the first tab of 5 diferent spreadsheets and then stack them
vertically one after the other.

I've been able to get this partially implemented by placing formulas
in the cells in the target spreadsheet that go out and import the
contents from the five different spreadsheets but here are the
problems I would still like to overcome:

1) The number of rows in the five source spreadsheets can vary from
time to time and I would like to avoid having large blank areas
between the stacked results.

2) Importing the info from the other spreadsheets only brings the cell
contents, I would like to bring the formating info along with the
contents.

Any suggestions on how to address these two itmes would be greatly
appreciated!


John Keith
[email protected]
 
D

DanF

Spooky - this is exactly what I came on here for tips for!
If I find anythig out I'll post it here!
 
R

Roger Govier

Hi John

Ron de Bruin has lost of code at his site for combining Worksheets and
Workbooks.
Take a look at
http://www.rondebruin.nl/copy2.htm

If you read right through, you will see Ron has notes on how to copy from 1
sheet only, rather than each sheet in the workbook
 
Top