Copy Multiple Sheets Into One Sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael - 26 Jun 2007 17:10 GMT

Hi Folks - I track monthly sales in separate worksheets (Jan, Feb, Mar,
etc.). At the end of the year, I need to analyze the monthly sales figures
on a yearly basis. So, I create a new sheet and copy the individual monthly
sheet data to the new sheet. This is a little time consuming. Is there a
more efficient way to basically merge and append multiple sheets into one
sheet? Thanks in advance.

Michael

Reply to this Message

Ron de Bruin - 26 Jun 2007 17:28 GMT

Hi Michael

See my site for a few examples
http://www.rondebruin.nl/copy3.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hi Folks - I track monthly sales in separate worksheets (Jan, Feb, Mar,
> etc.). At the end of the year, I need to analyze the monthly sales figures
[quoted text clipped - 4 lines]
>
> Michael

Reply to this Message

Ron de Bruin - 26 Jun 2007 18:18 GMT

Sorry I post the wrong link
Try
http://www.rondebruin.nl/copy2.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hi Michael
>
[quoted text clipped - 9 lines]
>>
>> Michael

Reply to this Message

Earl Kiosterud - 26 Jun 2007 18:12 GMT

Michael,
Take a look at "Data across multiple sheets" at
http://www.smokeylake.com/excel/excel_truths.htm

Signature

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

> Hi Folks - I track monthly sales in separate worksheets (Jan, Feb, Mar, etc.). At the end
> of the year, I need to analyze the monthly sales figures on a yearly basis. So, I create a
[quoted text clipped - 3 lines]
>
> Michael

Reply to this Message

Mr. K - 27 Jun 2007 00:39 GMT

Michael,

There are many solutions for this problem, it depends on how many
cells you are talking about, layout of your worksheet or import format
of all of this data.
1) Hard work - having a sample layout to consolidate all worksheets,
linking each cell with hlookup or vlookup. Any additional data will
make you add more formulas to link these cells.

2) Pivot table. Join all data in a specific format, then add for each
worksheet a column indicating the month reference. Copy all 12 months
in consolidated worksheet. Use pivot table to handle and consolidate
all information as you want.Using pivot table you can create custom
formulas and analyze data dynamically.
3) Other suggestions mentioned in replies sent before to you.

Have a good luck.

Mr. K
Brazil

> Hi Folks - I track monthly sales in separate worksheets (Jan, Feb, Mar,
> etc.). At the end of the year, I need to analyze the monthly sales figures
[quoted text clipped - 4 lines]
>
> Michael

Reply to this Message