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.

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.

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.

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.

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.

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.

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.