| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to Append worksheets in the same excel file?
http://www.rondebruin.nl/summary.htm
-- Regards, Peo Sjoblom "Angie33" wrote in message ... Maybe I did not explain myself correctly, the column headings in each sheet are the only things that are the same in each tab, the rest of the information is completely different. I simply want to append or attach all the worksheets into one worksheet. Instead of having four separate worksheets, all of the information which is all different will be on one worksheet. Thanks. -- Angie33 "Angie33" wrote: I don't know if this is possible, but I would like to append worksheets in the same file. I have 5 different tabs of information. All have the same columns. I would rather not copy and paste from one worksheet to the other for fear of lossing information as I move from one worksheet to the next. Does anyone know if there is a way to append various worksheets in file into one worksheet? The information in each tab (worksheet) has over 1000 or more lines of information, if I could append it I would ensure that everything has been included. Why not use copy? Because when I have had to copy large amounts of information, a few thousand lines of info, if I copy it into a word file or note book and bring it back into excel, many times some of the information is missing. If anyone has a solution, I would appreciate the help. -- Angie33 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I append 20 worksheets in single sheet. | Excel Worksheet Functions | |||
| Append Excel Sheet from constantly updating delimited text file | Setting up and Configuration of Excel | |||
| how can I Append values to an existing excel file. | New Users to Excel | |||
| Append worksheets together in one | Excel Discussion (Misc queries) | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
![Peo Sjoblom[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
