combining worksheets

[jolowe]

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.

 

[Pete_UK]

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

 

[jolowe]

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.

 

[satadru]

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.

 

[Roger Govier]

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

 

[jolowe]

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]

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.