Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining worksheets
I need to combine two worksheets into one. The sheets have written
information on them - they are set up in rows/columns- the are formatted exactly the same. I do not want to loose the information on any of the lines, I just want to put all the information together on one worksheet according to column headings. I frequently need to do this - and doing it "by hand" is very time consuming - there must be a better way. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining worksheets
Can't you just <copy the data from the second sheet and <paste it at
the bottom of the data in the first sheet? Only takes a few seconds !! Hope this helps. Pete On Aug 29, 12:35*am, jolowe wrote: I need to combine two worksheets into one. *The sheets have written information on them - they are set up in rows/columns- the are formatted exactly the same. *I do not want to loose the information on any of the lines, I just want to put all the information together on one worksheet according to column headings. *I frequently need to do this - and doing it "by hand" is very time consuming - there must be a better way. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining worksheets
Pete, of course I could do that - BUT - I need the information in order - and
it is in order on both the worksheets (ie. Col. B is the same on both sheets - the data is in Col's c,d,e,f,g,h - the data on each line is in the order it was added) I need to have it in the same order when combined. But thank you for the thought. "Pete_UK" wrote: Can't you just <copy the data from the second sheet and <paste it at the bottom of the data in the first sheet? Only takes a few seconds !! Hope this helps. Pete On Aug 29, 12:35 am, jolowe wrote: I need to combine two worksheets into one. The sheets have written information on them - they are set up in rows/columns- the are formatted exactly the same. I do not want to loose the information on any of the lines, I just want to put all the information together on one worksheet according to column headings. I frequently need to do this - and doing it "by hand" is very time consuming - there must be a better way. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining worksheets
I have a similar problem, too. I think auto-sort is what is required in this
case. The only issue that I have here, is that I do not know the VBA code to do this. "jolowe" wrote: Pete, of course I could do that - BUT - I need the information in order - and it is in order on both the worksheets (ie. Col. B is the same on both sheets - the data is in Col's c,d,e,f,g,h - the data on each line is in the order it was added) I need to have it in the same order when combined. But thank you for the thought. "Pete_UK" wrote: Can't you just <copy the data from the second sheet and <paste it at the bottom of the data in the first sheet? Only takes a few seconds !! Hope this helps. Pete On Aug 29, 12:35 am, jolowe wrote: I need to combine two worksheets into one. The sheets have written information on them - they are set up in rows/columns- the are formatted exactly the same. I do not want to loose the information on any of the lines, I just want to put all the information together on one worksheet according to column headings. I frequently need to do this - and doing it "by hand" is very time consuming - there must be a better way. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining worksheets
Hi
Could you can post some example lines from each sheet, and explain what you want the combined sheet to look like, again with examples. From your description so far, I cannot tell what it is you are wanting to achieve -- Regards Roger Govier "jolowe" wrote in message ... Pete, of course I could do that - BUT - I need the information in order - and it is in order on both the worksheets (ie. Col. B is the same on both sheets - the data is in Col's c,d,e,f,g,h - the data on each line is in the order it was added) I need to have it in the same order when combined. But thank you for the thought. "Pete_UK" wrote: Can't you just <copy the data from the second sheet and <paste it at the bottom of the data in the first sheet? Only takes a few seconds !! Hope this helps. Pete On Aug 29, 12:35 am, jolowe wrote: I need to combine two worksheets into one. The sheets have written information on them - they are set up in rows/columns- the are formatted exactly the same. I do not want to loose the information on any of the lines, I just want to put all the information together on one worksheet according to column headings. I frequently need to do this - and doing it "by hand" is very time consuming - there must be a better way. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining worksheets
Roger - thank you for your interest - and I would love to "can post" an
example if I only knew what it was and how to do it ??? I have reasonable good knowledge of computers but I do not know the "how to" of what you want me to do. If you can explain it I can do it (I think). Thanks again Joanne "Roger Govier" wrote: Hi Could you can post some example lines from each sheet, and explain what you want the combined sheet to look like, again with examples. From your description so far, I cannot tell what it is you are wanting to achieve -- Regards Roger Govier "jolowe" wrote in message ... Pete, of course I could do that - BUT - I need the information in order - and it is in order on both the worksheets (ie. Col. B is the same on both sheets - the data is in Col's c,d,e,f,g,h - the data on each line is in the order it was added) I need to have it in the same order when combined. But thank you for the thought. "Pete_UK" wrote: Can't you just <copy the data from the second sheet and <paste it at the bottom of the data in the first sheet? Only takes a few seconds !! Hope this helps. Pete On Aug 29, 12:35 am, jolowe wrote: I need to combine two worksheets into one. The sheets have written information on them - they are set up in rows/columns- the are formatted exactly the same. I do not want to loose the information on any of the lines, I just want to put all the information together on one worksheet according to column headings. I frequently need to do this - and doing it "by hand" is very time consuming - there must be a better way. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining worksheets
Hi Joanne
If it is easier for you, just mail me a copy of the workbook with an explanation of what you want to see on the Summary page. To mail direct, send to roger at technology4u dot co dot uk Change the at and dots to make a valid email address. -- Regards Roger Govier "jolowe" wrote in message ... Roger - thank you for your interest - and I would love to "can post" an example if I only knew what it was and how to do it ??? I have reasonable good knowledge of computers but I do not know the "how to" of what you want me to do. If you can explain it I can do it (I think). Thanks again Joanne "Roger Govier" wrote: Hi Could you can post some example lines from each sheet, and explain what you want the combined sheet to look like, again with examples. From your description so far, I cannot tell what it is you are wanting to achieve -- Regards Roger Govier "jolowe" wrote in message ... Pete, of course I could do that - BUT - I need the information in order - and it is in order on both the worksheets (ie. Col. B is the same on both sheets - the data is in Col's c,d,e,f,g,h - the data on each line is in the order it was added) I need to have it in the same order when combined. But thank you for the thought. "Pete_UK" wrote: Can't you just <copy the data from the second sheet and <paste it at the bottom of the data in the first sheet? Only takes a few seconds !! Hope this helps. Pete On Aug 29, 12:35 am, jolowe wrote: I need to combine two worksheets into one. The sheets have written information on them - they are set up in rows/columns- the are formatted exactly the same. I do not want to loose the information on any of the lines, I just want to put all the information together on one worksheet according to column headings. I frequently need to do this - and doing it "by hand" is very time consuming - there must be a better way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining worksheets | Excel Worksheet Functions | |||
Combining worksheets | New Users to Excel | |||
Combining Worksheets | Excel Worksheet Functions | |||
Combining Worksheets into one | Excel Worksheet Functions | |||
Combining 2 or more worksheets | Excel Worksheet Functions |