Data is on several sheets, i want it on one...?
 

Hi,

I have a workbook with an undefined number of sheets in it. On each of
these sheets i have a body of data. I'd like to be able to look at all
this data in total on one sheet.

For example, i have a phone bill for each month on seperate worksheets
and i want to be able to analyse the whole call activity over the total
time.

Is it possible to use a macro to pull all this data into a summary
sheet that i can then analyse?

Many thanks in advance for your help


--
iwilkin
------------------------------------------------------------------------
iwilkin's Profile: http://www.excelforum.com/member.php...o&userid=16072
View this thread: http://www.excelforum.com/showthread...hreadid=373455

Data is on several sheets, i want it on one...?
 

What is the naming convention for the sheets? Does it use Sheet1, Sheet2,
etc. or the month name or the date range, or something?


"iwilkin" wrote in message
...

Hi,

I have a workbook with an undefined number of sheets in it. On each of
these sheets i have a body of data. I'd like to be able to look at all
this data in total on one sheet.

For example, i have a phone bill for each month on seperate worksheets
and i want to be able to analyse the whole call activity over the total
time.

Is it possible to use a macro to pull all this data into a summary
sheet that i can then analyse?

Many thanks in advance for your help


--
iwilkin
------------------------------------------------------------------------
iwilkin's Profile:
http://www.excelforum.com/member.php...o&userid=16072
View this thread: http://www.excelforum.com/showthread...hreadid=373455

Data is on several sheets, i want it on one...?
 

See
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"iwilkin" wrote in message ...

Hi,

I have a workbook with an undefined number of sheets in it. On each of
these sheets i have a body of data. I'd like to be able to look at all
this data in total on one sheet.

For example, i have a phone bill for each month on seperate worksheets
and i want to be able to analyse the whole call activity over the total
time.

Is it possible to use a macro to pull all this data into a summary
sheet that i can then analyse?

Many thanks in advance for your help


--
iwilkin
------------------------------------------------------------------------
iwilkin's Profile: http://www.excelforum.com/member.php...o&userid=16072
View this thread: http://www.excelforum.com/showthread...hreadid=373455