Home |
Search |
Today's Posts |
#1
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
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Data help? | Excel Discussion (Misc queries) | |||
Combining Data | Excel Discussion (Misc queries) | |||
combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
combining data | Excel Worksheet Functions | |||
Combining Data | Excel Discussion (Misc queries) |