Gathering Info on one sheet

A

albertmb

Hi everyone,

I have this problem: info is entered in 12 sheets (representing a sheet for
each month). The amount of rows used can not be determened beforehand, i.e.
on sheet1 I might use 300 rows and on Sheet2 I might use 400. But the colomns
are identical on each sheet.
Is it possible to gather the information from all twelve sheets in one sheet?

Thank you
 

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

Code to format cells on several worksheets 2
Help changing the sheet name 3
Many sheets, one DB? 1
Copy rows to new sheet based on value in column A 0
Need a Macro to combine 1-5 sheets in one sheet 1
Help with show info on one row in Excel 2007 0
Linking cells from the previous sheet 10
presenting data on multiple sheet on one consolidated sheet 2

Top