Search the Community

After starting my previous thread "What formula will work to acieve 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 No SUB No. DESCRIPTION ** UNIT QUANTITY A1234 94456 TYPE A, XXXX XXX * * * * EA ** * * * 45 A4235 20374 YA1AM, XXXXXXXXXX * **EA ** * * * 55 A1482 31375 TYPE B, XXXXXXXXX * * * EA ** * * * 33 A1461 51725 A1AAM, XXXXXXXXXX * * EA ** * * * 67 A1356 21873 TYPE 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. I will really appreciate a Speedy solution....soon