Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same Row merge to Second worksheet
I have a little problem with a few of the worksheets that have been given to
me. It looks like they have merged two and maybe three worksheets into one and I have to seperate them. The common two colume is a CAT Number and DESCRIPTION. What I need if it is possible to look at the CAT# number and if it is the same as the next row place bith rows into another worksheet. I can then go down through that worksheet and figure out if it is needed or not. CAT# COST LOCATION DESCRIPTION REORDERPT QUAN LAST PUR 1223 1.20 I7R2 Joint 20 5 01/23/05 1223 1.20 I7R2 nuckle 20 5 01/23/05 1245 7.20 IAR1 Paste 10 2 11/14/04 1254 3.40 I6R2 Backing 15 3 12/13/04 1401 1.25 I4R7 Backing 100 20 02/10/05 1401 1.25 I4R7 Backing 100 20 02/10/05 1502 2.10 I3R9 Jell 30 10 01/09/05 1506 1.76 I3R6 Paste 20 5 01/21/05 1506 1.76 I8R3 Paste 15 2 01/15/05 What I would like to see on the second worksheet would be all of the info from every duplicate Cat#, is this possible? Thank in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to merge columns from one worksheet to another worksheet | Excel Worksheet Functions | |||
how to merge separate worksheet | Excel Worksheet Functions | |||
how do I merge a worksheet into another one? | New Users to Excel | |||
How to merge more than one worksheet | Excel Worksheet Functions | |||
Merge 2 rows in worksheet | Excel Discussion (Misc queries) |