Excel VBA Data Help

I have several macros that were created by someone else that needs modified. Basically, the macro runs and the outcome is 90% of what I need it to be. However, I need to take the data the macro creates, turn it into a table, filter one of the columns, then provide some cells to total the amounts. That's it. I am new to VBA and I just to someone to make the aforementioned changes to the macro.