Archive of Mr Excel Message Board


Back to Data in Excel archive index
Back to archive home

copy a line

Posted by M.A.C on November 19, 2001 12:25 AM
On a sheet containing 10 columns,column number 3 is for a customer order number,what i need is all the lines that contain that order number copying to another sheet (sheet 2)

can this be done?
cheers in advance

mac


Re: copy a line

Posted by Mike on November 19, 2001 5:09 AM


MAc,
Couple of questions first.
Does coulmn 3 only contain one specific order
number or do the order numbers vary?

Do you want this to be done using a macro?

It's probably less of a hastle by using the Data filter, then copy and paste. Are you familiar
with the Data Filter?

Mike


Re: copy a line

Posted by mac on November 19, 2001 6:57 AM

mike,
the order number in column 3 is usually different,
i would prefer to use a macro, the reason for the task is to analise how many and description of items remaining on a particular order number

regards,

mac


Re: copy a line

Posted by Mike on November 19, 2001 7:42 AM

* * * *

mac,
using the Data Filter could be the easiest way to go.
first click and drag to hi-lite the header row.
then click on Data, slide down to Filter, slide over and click on Auto Filter.
You'll see a bunch of arrows appear in the lower
right hand corner of each cell. click on the arrow in the cell that lists your order #'s, and slide down to click on a specific order number.
All the lines that pertain to that specific order# will then be shown. You can then copy the info to another sheet, or print from here.

Let me know if this is what you are looking for.

Mike

* * * * *


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.