Share via

VBA Code to dump information from a table based on the account codes

Anonymous
2024-04-03T13:39:17+00:00

I am busy with an audit and I would like to automatically dump accounts and transactions based on the account numbers without using the filter and copy/paste method, as there are multiple accounts that I need to go through and it is going to take a lot of time. Is there a VBA code that I can use to do this exercise in one practice?

Microsoft 365 and Office | Excel | Other | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-03T14:12:56+00:00

    Hi, I am a Microsoft user just like yourself and I will try my best to help you as much as I can today.

    I can help you with a VBA code but I need a bit more information like: The layout of your data (e.g., which columns contain the account numbers and transaction details). Where you want to copy the filtered transactions (e.g., a new sheet, a specific range on the same sheet). Any specific criteria for selecting transactions (e.g., only transactions for certain account)

    Best regards Deeksha

    Was this answer helpful?

    0 comments