adding a "relationship code" to a worksheet

[pat67]

Hi. what I mean by "relationship code" is this. a relationship between
transactions. Here is a sample of what I have and need.

Have

PO Item Type Material Number MvT Pstg date
12345 10 NB 789 101 1/6/2009
12345 10 NB 789 321 1/8/2009
12345 20 NB ABC 101 1/7/2009
12345 20 NB ABC 101 1/7/2009
12345 20 NB ABC 321 1/8/2009
12345 20 NB ABC 321 1/8/2009
56789 60 NB A1A 101 2/4/2009
56789 60 NB A1A 321 2/5/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009


Need

PO Item Type Material Number MvT Pstg date Code
12345 10 NB 789 101 1/6/2009 1000
12345 10 NB 789 321 1/8/2009 1000
12345 20 NB ABC 101 1/7/2009 1000
12345 20 NB ABC 101 1/7/2009 1001
12345 20 NB ABC 321 1/8/2009 1000
12345 20 NB ABC 321 1/8/2009 1001
56789 60 NB A1A 101 2/4/2009 1000
56789 60 NB A1A 321 2/5/2009 1000
56789 90 NB AAA 101 1/13/2009 1000
56789 90 NB AAA 101 1/13/2009 1001
56789 90 NB AAA 101 1/13/2009 1002
56789 90 NB AAA 101 1/13/2009 1003
56789 90 NB AAA 101 1/13/2009 1004
56789 90 NB AAA 101 1/13/2009 1005
56789 90 NB AAA 101 1/13/2009 1006
56789 90 NB AAA 321 1/16/2009 1000
56789 90 NB AAA 321 1/16/2009 1001
56789 90 NB AAA 321 1/16/2009 1002
56789 90 NB AAA 321 1/16/2009 1003
56789 90 NB AAA 321 1/16/2009 1004
56789 90 NB AAA 321 1/16/2009 1005
56789 90 NB AAA 321 1/16/2009 1006

The code can be anything. I just used 1000. This way, I can export to
Access and then get the information I need. Can someone assist me?

Thanks

 

[Chip Pearson]

You need to describe clear how two or more transactions are related?
What piece of information ties one transaction to another?

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

 

[Herbert Seidenberg]

Excel 2007 Table
Assign count of repetitions of a unique row,
to the row,
starting from the first row,
and ending at the current row.
Table needs not to be sorted.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/01_16_10.xlsx

 

[pat67]

Excel 2007 Table
Assign count of repetitions of a unique row,
to the row,
starting from the first row,
and ending at the current row.
Table needs not to be sorted.http://c0444202.cdn.cloudfiles.rackspacecloud.com/01_16_10.xlsx

Thanks. That works perfectly