+ Reply to Thread
Results 1 to 2 of 2

Recon balance and separating of data that balances to zero

  1. #1
    Registered User
    Join Date
    02-23-2021
    Location
    Missouri, US
    MS-Off Ver
    365
    Posts
    2

    Recon balance and separating of data that balances to zero

    My most current task is going through the tax recons I'm in charge of and finding the entries that balance. And biggest road block is currently running into the possibilty that the descriptions/ explanations might not match 100%, there are lots of the same descriptions with no differentiating factors like (1,2,3 ...etc) or 1 dr/cr could have multiple offsetting entries to balance. Currently what I have to done is used the unique formula for the amount's column, and then used =if(countif($M6:M$77,M6)=2,"x","") to find the matching unique. And the used the filter formula to pull all my matching to a separate part of worksheet. But this only gives the obvious matches.
    I have not experience with queries, basic knowledge of pivot tables, and I have little experience with formulas, as my last position we did everything manually (not an ounce of excel formula usage or anything fancy).
    This recon is one where I pull 10-100 accounts from E1 and put that table into a formula (array?) my boss put together that will separate all the accounts with activity and give me a variance based on the what are in the individual account tabs verses what I just inputted in the the formula. And then I have to go and collect the individual account entry detail to balance the tabs to that give me account varriance. And it's this last part I want to have something put together that can pull the matches to make sure they are balancing to "0" whether its 2=0 or 10= 0.
    I have 20+ tabs I will need to repeat this on.
    And if a VBA or Macro is my only solution, I need very detailed instructions on how to set these up. I've never set one up ever. I'm a novice.
    Last edited by mcdonaldalyshia; 02-24-2021 at 04:45 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,745

    Re: Pointers in the right direction please

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Porting VBA to MAC - pointers and hints.
    By PhilB2 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-18-2021, 04:44 AM
  2. Replies: 8
    Last Post: 07-12-2017, 05:05 PM
  3. Mouse Pointers
    By wambaugh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2012, 08:20 AM
  4. object pointers
    By rando4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2005, 11:05 PM
  5. Could someone give me some pointers
    By mykaltx in forum Excel General
    Replies: 2
    Last Post: 08-16-2005, 04:32 PM
  6. Pointers??
    By OzziJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-24-2005, 04:05 AM
  7. Pointers??
    By OzziJC in forum Excel General
    Replies: 2
    Last Post: 06-22-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1