| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| Chart sheets cause data sheets to be blank | Charts and Charting in Excel | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
