|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 25th, 2010, 06:54 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining data
I'm sure there is a formula out there to do this, but I'm not finding any
help in the help function in excel. I have one worksheet for each day of the month with data. I'm looking to take the data from each of those sheets and dump it all into one "summary sheet" instead of having to copy and paste each day (I'm not looking to summarize any of it). If a new sheet is added, I would like to have the data added to the bottom of the "summary sheet" Any suggestions as to how to do this? 
|
|
#2
March 25th, 2010, 06:57 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining data
Hi,
Ron has a macro to do that look into http://www.rondebruin.nl/copy2.htm "nitengale" wrote: I'm sure there is a formula out there to do this, but I'm not finding any help in the help function in excel. I have one worksheet for each day of the month with data. I'm looking to take the data from each of those sheets and dump it all into one "summary sheet" instead of having to copy and paste each day (I'm not looking to summarize any of it). If a new sheet is added, I would like to have the data added to the bottom of the "summary sheet" Any suggestions as to how to do this?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
