can this be done?
cheers in advance
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?
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
* * * *
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.
* * * * *