I have an excel sheet with more than 10 000 lines, here's the struture
of my sheet:

Cost Center: 5496 obsus

10:00 fluorouracil- 5000mg/100ml vial
10:00 irinotecan- 100mg/5ml vial 21
92:00 folinic acid inj- 500mg/50ml vial 90
Sub Account: 470102 Subtotal:
24:04.08 digoxin- 0.5mg/2ml ampul 10
Sub Account: 470112 Subtotal:
40:12 potassium chloride inj- 20meq/10ml vial
Sub Account: 470115 Subtotal: 8.69
56:22.20 ondansetron inj- 40mg/20ml vial
Sub Account: 470117 Subtotal:
68:04 dexamethasone inj- 10mg/ml vial
Sub Account: 470118 Subtotal: 0.65
38:00 glutaraldehyde 3.8l- 2% solution 4
84:04.92 chlorhexidine soap- 4%-4.5l solution
96:00 lubricating jelly- 150 g gel 20
Sub Account: 489609 Subtotal:
Charge Cost: 2386.21
Credit Cost: 0
Total Net Cost: 2386.21


Cost Center: 6021 4 utt
Code:
--------------------

--------------------


.....
.....


My question is how can I index each row, I would like to put the cost
center number before each row , because i would like to generate some
reports in Access.

example:


Cost Center: 5496 obsus

*5496* 10:00 fluorouracil- 5000mg/100ml vial
*5496* 10:00 irinotecan- 100mg/5ml vial
*5496* 92:00 folinic acid inj- 500mg/50ml vial
*5496* Sub Account: 470102 Subtotal:
*5496* 24:04.08 digoxin- 0.5mg/2ml ampul
*5496* Sub Account: 470112 Subtotal:
*5496* 40:12 potassium chloride inj- 20meq/10ml vial
*5496* Sub Account: 470115 Subtotal: 8.69

*5496* Charge Cost: 2386.21
*5496* Credit Cost: 0
*5496 * Total Net Cost: 2386.21


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=388070