I download bank statement info in csv format and import it into Excel 2010. Column D has the total amount of the transaction and Column E the GST amount. Then I have 10 or so columns to the left to show which expense category it is eg Tools, Phone etc. How can I record a formula or macro to be able to select the cell under 'Tools' or whatever and calculate column D amount less column E amount for that row?
Bookmarks