In Excel 2010 32-bit, I'm going to be creating an Excel-based macro that will launch the creation of a pivot table. After I have created the pivot table, I need for the macro to subtract the second row of data from the first row of data.
The first column is ITEM, the second is ITEM DESCRIPTION, the third is LOCATION, and the fourth and final column is QTY.
There are two locations--location 1 and location 2. Each item has these two locations.
There will be two rows in each set of data, so it will need to be some sort of automatic subtraction for the entire spreadsheet of data. Normally, I could do this by clicking the subtotal button. But, it's not "totaling" that I want. It's subtracting.
Thanks! Any help is much appreciated!