Help in VBA

GTR44844

New Member
Joined
Sep 4, 2013
Messages
1
I need help in creating VBA to match two different sheets. the only link between them is item description, but names are not 100% identical. I tried to do a loop that finds the description in each cell in Sheet1 and match in Sheet2 and then find the items cost of each item.

check the sample below.
[TABLE="width: 1291"]
<tbody>[TR]
[TD="class: xl67, width: 788, bgcolor: #E7F3FD"]Item Description
[/TD]
[TD="class: xl67, width: 64, bgcolor: #E7F3FD"]Item Cost
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 677, bgcolor: #E6B8B7"]DEPT_MISC_LINE
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]PARACETAMOL|| 250 mg suppository
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]0.1795
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #24
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]EPINEPHRINE|| 1 mg/mL (1:1,000) 1 mL injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]1.83866
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #24
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]INSULIN LISPRO|| 100 units/mL injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]83.71223
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Alginic Acid Compound Suspension T10 SUSP PO Q6H DAY7 prn hburn #200
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]LIDOCAINE|| 2% gel
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]5.91142
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Alginic Acid Compound Suspension T10 SUSP PO Q6H DAY7 prn hburn #200
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]METOCLOPRAMIDE|| 5 mg/mL (2 mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]0.97879
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Alginic Acid Compound Suspension 20 ml po qid prn hburn day 14 #1000
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]OXYTOCIN|| 5 IU/mL (1 mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]1.7989
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 prn pain #24
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]TEICOPLANIN|| 200 mg vial (injection)
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]133.2249
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Ibuprofen 400mg Tablet T1 TAB PO TIDPC DAY5 prn pinf #15
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]XYLOMETAZOLINE|| 0.1% nasal spray (adult)
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]4.43829
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Amoxicillin-Clavulanate 875mg-125mg Tablet 1 po pc bid q12h day 7 #14
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]XYLOMETAZOLINE|| 0.05% nasal drops (pediatric)
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]3.68699
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #24
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]KETOROLAC|| 30 mg/mL (1 mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]4.80156
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Desloratidine 5mg Tablet T1 TAB PO D DAY10 eve #10
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]HETASTARCH|| 6% solution (500 mL) for infusion
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]28.63
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #24
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]PARACETAMOL|| 500 mg tablet
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]0.02887
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Ascorbic Acid (effervescent) 1000mg Tablet DD1 TAB-EFF PO D DAY14 #20
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]BUPIVACAINE|| 0.5% "HEAVY" preservative-free (spinal) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]13.22805
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Atorvastatin 10mg Tablet T1 TAB PO HS DAY90 #90
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]DICLOFENAC SODIUM|| 100 mg suppository
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]1.39871
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Ergocalciferol 50,000 units Capsule T2 CAP PO Q7D DAY90 #12
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]DICLOFENAC SODIUM|| 100 mg suppository
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]1.39871
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Calcium Carbonate-Vitamin D 600mg-200units Tablet T1 TAB PO BID DAY90 #180
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]ERGOMETRINE MALEATE SYNTHETIC OXYTOCIN|| 0.5 mg + 5I.U/mL (1 mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]14.95007
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Vildagliptin-Metformin 50mg-1000mg Tablet T1 TAB PO BID DAY90 #180
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]LIDOCAINE|| 2% (50 mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]4.04046
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Pseudoephedrine-Triprolidine 60mg-2.5mg Tab T1 TAB PO Q8H DAY3 MCD #10
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]LIDOCAINE|| 10% endotracheal spray
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]25.37894
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY3 PRN PF #24
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]OXYTOCIN|| 5 IU/mL (1 mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]1.7989
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Xylometazoline 0.1% (10mL) Nasal Spray SP1 SPRAY EN Q8H DAY3 NASCONG #1
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]OXYTOCIN|| 5 IU/mL (1 mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]1.7989
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #0
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]PHYTOMENADIONE|| 10 mg/mL (0.2 mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]2.7549
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #0
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]ROCURONIUM|| 10 mg/mL (5mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]19.87276
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Paracetamol 24mg/mL Suspension 8 ML PO Q4H PRN PF #200
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]LIDOCAINE|| 1% (20 mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]1.95
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Neomycin/PolymixinB/Hydrocortisone (5mL) Ear Drops I4 DROPS AD TID DAY7 #1
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]LIDOCAINE|| 1% (20 mL) injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]1.95
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Docusate (Ear Wax Removal) 0.5% (10mL) Ear Drops I8 DROPS AU HS DAY2 #1
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]PARACETAMOL||10 mg/mL (100 mL) vial injection
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]11.75051
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Ibuprofen 400mg Tablet T1 TAB PO BID DAY7 PRN PINF #15
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]BALANCED SALT SOLUTION|| eye drops
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]12.49882
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #24
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]BUDESONIDE|| 0.5 mg/mL (2 mL) nebule (for inhalation)
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]6.53829
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Ascorbic Acid (effervescent) 1000mg Tablet DD1 TAB-EFF PO D DAY14 #20
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]DOCUSATE (EAR WAX REMOVAL)|| 0.5% ear drops
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]2.51422
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Pseudoephedrine-Triprolidine 60mg-2.5mg Tab T1 TAB PO Q8H DAY4 MCD #12
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]ERYTHROMYCIN|| 0.5% eye ointment
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]7.53643
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Xylometazoline 0.1% (10mL) Nasal Spray SP1 SPRAY EN Q8H DAY3 #1
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]FLUORESCEIN|| 2% eye drops (minims)
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]3.74992
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Amoxicillin-Clavulanate 80mg-11.4mg/mL Susp 2.5 ML PO PC BID Q12H DAY 7 FRIDGE AND SHAKEWELL #70
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]FUSIDIC ACID / BETAMETHASONE|| 20 mg / 1 mg (per gram) cream
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]9.76567
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Paracetamol 24mg/mL Suspension 7 ML PO TID DAY 5 PRN PF #100
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]FUSIDIC ACID|| 2% cream
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]2.44014
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Cetirizine 1mg/mL Solution T2 SOL PO D DAY5 EVE #75
[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 788, bgcolor: white"]VACCINE , HEPATITIS B VACCINE RECOMBINANT , (INACTIVATED) ( HEP B ADULT.) || 20 mcg (adult) injection ( single dose )
[/TD]
[TD="class: xl68, width: 64, bgcolor: white"]0
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Paracetamol 24mg/mL Suspension 6 ML PO TID DAY 5 PRN PF #100
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Cetirizine 1mg/mL Solution T2 SOL PO D DAY5 #75
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Amoxicillin-Clavulanate 80mg-11.4mg/mL Susp 2.5 ML PO BID DAY 7 FRIDGE AND SHAKEWELL #70
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #DCE6F1"]Electrolyte for Rehydration (Neolyte) Sachet ORS2 140ML PO TID DAY3 #1260
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: #B8CCE4"]Electrolyte for Rehydration (Neolyte) Sachet ORS2 140ML PO TID DAY3 #1260
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1721"]
<tbody>[TR]
[TD]Item Description
[/TD]
[TD]Item Cost
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPT_MISC_LINE
[/TD]
[/TR]
[TR]
[TD]PARACETAMOL|| 250 mg supposito
[/TD]
[TD]0.1795
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #24
[/TD]
[/TR]
[TR]
[TD]EPINEPHRINE|| 1 mg/mL (1:1,000) 1 mL injection
[/TD]
[TD]1.83866
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #24
[/TD]
[/TR]
[TR]
[TD]INSULIN LISPRO|| 100 units/mL injection
[/TD]
[TD]83.71223
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alginic Acid Compound Suspension T10 SUSP PO Q6H DAY7 prn hburn #200
[/TD]
[/TR]
[TR]
[TD]LIDOCAINE|| 2% gel
[/TD]
[TD]5.91142
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alginic Acid Compound Suspension T10 SUSP PO Q6H DAY7 prn hburn #200
[/TD]
[/TR]
[TR]
[TD]METOCLOPRAMIDE|| 5 mg/mL (2 mL) injection
[/TD]
[TD]0.97879
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alginic Acid Compound Suspension 20 ml po qid prn hburn day 14 #1000
[/TD]
[/TR]
[TR]
[TD]OXYTOCIN|| 5 IU/mL (1 mL) injection
[/TD]
[TD]1.7989
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 prn pain #24
[/TD]
[/TR]
[TR]
[TD]TEICOPLANIN|| 200 mg vial (injection)
[/TD]
[TD]133.2249
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Ibuprofen 400mg Tablet T1 TAB PO TIDPC DAY5 prn pinf #15
[/TD]
[/TR]
[TR]
[TD]XYLOMETAZOLINE|| 0.1% nasal spray (adult)
[/TD]
[TD]4.43829
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Amoxicillin-Clavulanate 875mg-125mg Tablet 1 po pc bid q12h day 7 #14
[/TD]
[/TR]
[TR]
[TD]XYLOMETAZOLINE|| 0.05% nasal drops (pediatric)
[/TD]
[TD]3.68699
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #24
[/TD]
[/TR]
[TR]
[TD]KETOROLAC|| 30 mg/mL (1 mL) injection
[/TD]
[TD]4.80156
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Desloratidine 5mg Tablet T1 TAB PO D DAY10 eve #10
[/TD]
[/TR]
[TR]
[TD]HETASTARCH|| 6% solution (500 mL) for infusion
[/TD]
[TD]28.63
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #24
[/TD]
[/TR]
[TR]
[TD]PARACETAMOL|| 500 mg tablet
[/TD]
[TD]0.02887
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Ascorbic Acid (effervescent) 1000mg Tablet DD1 TAB-EFF PO D DAY14 #20
[/TD]
[/TR]
[TR]
[TD]BUPIVACAINE|| 0.5% "HEAVY" preservative-free (spinal) injection
[/TD]
[TD]13.22805
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Atorvastatin 10mg Tablet T1 TAB PO HS DAY90 #90
[/TD]
[/TR]
[TR]
[TD]DICLOFENAC SODIUM|| 100 mg suppository
[/TD]
[TD]1.39871
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Ergocalciferol 50,000 units Capsule T2 CAP PO Q7D DAY90 #12
[/TD]
[/TR]
[TR]
[TD]DICLOFENAC SODIUM|| 100 mg suppository
[/TD]
[TD]1.39871
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Calcium Carbonate-Vitamin D 600mg-200units Tablet T1 TAB PO BID DAY90 #180
[/TD]
[/TR]
[TR]
[TD]ERGOMETRINE MALEATE SYNTHETIC OXYTOCIN|| 0.5 mg + 5I.U/mL (1 mL) injection
[/TD]
[TD]14.95007
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Vildagliptin-Metformin 50mg-1000mg Tablet T1 TAB PO BID DAY90 #180
[/TD]
[/TR]
[TR]
[TD]LIDOCAINE|| 2% (50 mL) injection
[/TD]
[TD]4.04046
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Pseudoephedrine-Triprolidine 60mg-2.5mg Tab T1 TAB PO Q8H DAY3 MCD #10
[/TD]
[/TR]
[TR]
[TD]LIDOCAINE|| 10% endotracheal spray
[/TD]
[TD]25.37894
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY3 PRN PF #24
[/TD]
[/TR]
[TR]
[TD]OXYTOCIN|| 5 IU/mL (1 mL) injection
[/TD]
[TD]1.7989
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Xylometazoline 0.1% (10mL) Nasal Spray SP1 SPRAY EN Q8H DAY3 NASCONG #1
[/TD]
[/TR]
[TR]
[TD]OXYTOCIN|| 5 IU/mL (1 mL) injection
[/TD]
[TD]1.7989
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #0
[/TD]
[/TR]
[TR]
[TD]PHYTOMENADIONE|| 10 mg/mL (0.2 mL) injection
[/TD]
[TD]2.7549
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #0
[/TD]
[/TR]
[TR]
[TD]ROCURONIUM|| 10 mg/mL (5mL) injection
[/TD]
[TD]19.87276
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 24mg/mL Suspension 8 ML PO Q4H PRN PF #200
[/TD]
[/TR]
[TR]
[TD]LIDOCAINE|| 1% (20 mL) injection
[/TD]
[TD]1.95
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Neomycin/PolymixinB/Hydrocortisone (5mL) Ear Drops I4 DROPS AD TID DAY7 #1
[/TD]
[/TR]
[TR]
[TD]LIDOCAINE|| 1% (20 mL) injection
[/TD]
[TD]1.95
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Docusate (Ear Wax Removal) 0.5% (10mL) Ear Drops I8 DROPS AU HS DAY2 #1
[/TD]
[/TR]
[TR]
[TD]PARACETAMOL||10 mg/mL (100 mL) vial injection
[/TD]
[TD]11.75051
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Ibuprofen 400mg Tablet T1 TAB PO BID DAY7 PRN PINF #15
[/TD]
[/TR]
[TR]
[TD]BALANCED SALT SOLUTION|| eye drops
[/TD]
[TD]12.49882
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 500mg Tablet T2 TAB PO Q6H DAY5 #24
[/TD]
[/TR]
[TR]
[TD]BUDESONIDE|| 0.5 mg/mL (2 mL) nebule (for inhalation)
[/TD]
[TD]6.53829
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Ascorbic Acid (effervescent) 1000mg Tablet DD1 TAB-EFF PO D DAY14 #20
[/TD]
[/TR]
[TR]
[TD]DOCUSATE (EAR WAX REMOVAL)|| 0.5% ear drops
[/TD]
[TD]2.51422
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Pseudoephedrine-Triprolidine 60mg-2.5mg Tab T1 TAB PO Q8H DAY4 MCD #12
[/TD]
[/TR]
[TR]
[TD]ERYTHROMYCIN|| 0.5% eye ointment
[/TD]
[TD]7.53643
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Xylometazoline 0.1% (10mL) Nasal Spray SP1 SPRAY EN Q8H DAY3 #1
[/TD]
[/TR]
[TR]
[TD]FLUORESCEIN|| 2% eye drops (minims)
[/TD]
[TD]3.74992
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Amoxicillin-Clavulanate 80mg-11.4mg/mL Susp 2.5 ML PO PC BID Q12H DAY 7 FRIDGE AND SHAKEWELL #70
[/TD]
[/TR]
[TR]
[TD]FUSIDIC ACID / BETAMETHASONE|| 20 mg / 1 mg (per gram) cream
[/TD]
[TD]9.76567
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 24mg/mL Suspension 7 ML PO TID DAY 5 PRN PF #100
[/TD]
[/TR]
[TR]
[TD]FUSIDIC ACID|| 2% cream
[/TD]
[TD]2.44014
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Cetirizine 1mg/mL Solution T2 SOL PO D DAY5 EVE #75
[/TD]
[/TR]
[TR]
[TD]VACCINE , HEPATITIS B VACCINE RECOMBINANT , (INACTIVATED) ( HEP B ADULT.) || 20 mcg (adult) injection ( single dose )
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Paracetamol 24mg/mL Suspension 6 ML PO TID DAY 5 PRN PF #100
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Cetirizine 1mg/mL Solution T2 SOL PO D DAY5 #75
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Amoxicillin-Clavulanate 80mg-11.4mg/mL Susp 2.5 ML PO BID DAY 7 FRIDGE AND SHAKEWELL #70
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Electrolyte for Rehydration (Neolyte) Sachet ORS2 140ML PO TID DAY3 #1260
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Electrolyte for Rehydration (Neolyte) Sachet ORS2 140ML PO TID DAY3 #1260
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,223,240
Messages
6,170,951
Members
452,368
Latest member
jayp2104

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top