| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding a "relationship code" to a worksheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding data only if adjacent to cell labeled "male"/"female" | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| =SUM((C2:C7000="Friday")*(F2:F7000="8:00:00 AM")) not adding | Excel Discussion (Misc queries) | |||
| Adding "and" to Spellnumber code | Excel Discussion (Misc queries) | |||
| Adding a "CLEAR" button to the worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
