View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
iwilkin iwilkin is offline
external usenet poster
 
Posts: 1
Default 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