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.