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

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

"John Keith" wrote:

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

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

--
Regards
Roger Govier

"John Keith" wrote in message
...
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

Roger and DanF,

Each of your pointers look very promising to achieve my goal, thank
you very much for the info!


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

John Keith

Mate, i dunno if you found a solution to your problem, but a fella I spoke to
on another forum came up with a solution:

http://www.excelforum.com/showthread...=1#post1936204

"John Keith" wrote:

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