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
(e-mail address removed)
 
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
 
J

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
Click to expand...

John Keith
(e-mail address removed)
 

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

How do I consolidate data from several spreadsheets into one. 4
Code to format cells on several worksheets 2
Lookup+combine two spreadsheets into third 1
Trying to combine 2 Worksheets 1
combine data from several worksheets into single worksheet 2
multiple worksheets 1
Referencing worksheets 5
How do I combine data from several different worksheets in Excel? 3

Top