Copy Multiple Sheets Into One Sheet

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

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
 
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
 
Back
Top