AutoCad 2D :: Calculations To Create Macro Button In Excel

After starting my previous thread "What formula will work to achieve this result" I decided to post this new thread because I have changed my mind and will now be using the external Excel file that the "Extract Data" creates to do my calculations.

Here's what I would like to do: create a Macro [button] in Excel with the following conditions:
*
Sample of excel spreadsheet:
*
MANUF NoSUB No.DESCRIPTION** UNIT QUANTITY
A123494456TYPE A, XXXX XXX * * * * EA** * * * 45
A423520374YA1AM, XXXXXXXXXX * **EA** * * * 55
A148231375TYPE B, XXXXXXXXX * * * EA** * * * 33
A146151725A1AAM, XXXXXXXXXX * * EA** * * * 67
A135621873TYPE A, XXXXXXXXX * * * EA** * * * 24

1. * * * CONDITION #1:
IF "DESCRIPTION" TAB ["C" COLUMN] CONTAINS "TYPE A" AS PART OF TEXT/DESCRIPTION, TAKE THE "QUANTITY" TAB ["E" COLUMN] SPECIFIED ON THAT PARTICULAR ROW AND DIVIDE IT BY 20, ROUNDED UP TO NEAREST ONE.*

2. * * * CONDITION #2:
IF "DESCRIPTION" ["C" COLUMN] CONTAINS "TYPE B" AS PART OF TEXT/DESCRIPTION, TAKE THE "QUANTITY" SPECIFIED ON THAT PARTICULAR ROW ["E" COLUMN] AND DIVIDE IT BY 10, ROUNDED UP TO NEAREST ONE.

3. * * * AUTOMATICALLY SAVE THE EXCEL FILE AFTER THIS MACRO HAS BEEN UTILIZED.