A question from an intermediate Excel user regarding how to manipulate the data exported from TSM Accounting to Excel.
So I have a tab in my Excel file with all the auctions I've bought, and another tab with all the auctions I've sold. Some items appear on both tabs (i.e. stuff I've bought and resold) whereas most will not, such as mats bought and crafted items sold.
I would like to develop a formula (or maybe a macro?) to provide the data presented in the Resale tab in TSM Accounting. That is, extract only the items that appear in both tabs (bought AND sold), and summarize the total numbers.
How can this be done? An example formula would be great. If it needs to be a macro, I can probably figure out how to create one, once I know the macro to create.