Consulting

Results 1 to 7 of 7

Thread: VBA - Clean up a table with returning values

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Lightbulb VBA - Clean up a table with returning values

    Hi all,

    It often occurs to me to clear a general ledger. What happens here is that positive numbers are booked in column A and negative numbers in column B. In the end I'm dealing with hundreds of rows that book out each other (i.e. 500 left and 500 right = (+500-500=) 0) and I'm looking for lines that are not canceled ( and therefore remain open). I was wondering if someone has a way that this can be filtered automatically very quickly so that when I open such a table I can immediately extract what is open.

    An example is made in the file below.

    Thanks a lot for any help!

    Best,
    Jovanni
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •