• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    Very sorry but this latest workbook with your older code seems to work faster without any errors or issues with the banks.
  2. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    I attached this file which I used formulas to identify any differences that may occur between the tables for Transaction_IDs. See columns P and Q of Transactions sheet. I temporarily replaced the IDs to test. At this point there are no differences. Hopefully differences do not occur in the...
  3. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    I will try to figure out on my own I have taken up too much of your time. I am truly very sorry for this trouble that I have caused to you.
  4. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    When I used Sync I had duplicate accounts by their coding not sure why.
  5. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    Hello, The Transactions sheet table (Table1) is affected by Plaid Sync but not the entire sheet. I inserted another table in columns P and Q that is not affected by external code (Plaid Sync). So it seems to be less complicated if there are any Transaction_IDs that don't appear in both tables...
  6. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    Actually your new version is having conflict with bank information for some reason. I am not sure why.
  7. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    This version is acceptable thank you for your help. I have perhaps over stepped my requests.
  8. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    The data validation drop down lists are not correct on the Notes sheet. The Category column should be "=CategoryList" and the Subcategory column should start at "=INDIRECT(E4)" which is in cell F4. I changed it but it keeps going back so there must be code that is changing this. The attached...
  9. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    okay I will continue to use it and see if something or need comes up.
  10. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    I really value your opinion and if there is anything that you can think of that will improve this workbook please let me know. :)
  11. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    I was able to adapt your code to my workbook that has the correct transactions now. I will continue to test. I do hope also that someone else can benefit from your valuable work. Have a great day ahead! Thank you
  12. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    Yes they are the same but there will be future transactions that get imported when using the Plaid Sync code. I want to make sure that there will not be any differences as a cross check safety. Thank you if you can help me with that.
  13. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    I think I have it now. What does the number "4" in cell C1 mean? Is that the number of differences that may occur? At this point there aren't any so I don't know what that is for. What is the green highlight for in cell C2? Thank you
  14. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    I put it in the Transactions sheet because of the limited view in the Notes sheet. But I can see your point that sheet is not in my control and it make be affected by Plaid code. However if you can make it so the 2nd table in the Notes sheet is the way I had it before with the ApplyRules...
  15. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    Okay it is fine the way it is. Hopefully there will not be different Transaction IDs. Thank you
  16. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    Okay what I discovered in your latest version was the Refresh method for applying Category and Subcategory are not what I want. In my other version I would copy a line including Merchant, Category, and Subcategory to the table on the right in the Notes sheet. Then I would ApplyRules code. I do...
  17. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    I will test them out. Thank you
  18. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    I do not want drop down lists for Merchants. As far as what you say is new code I don't know what you mean. I am using your code.
  19. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    Hello, I really appreciate all of your help. What I have done now is find the Transaction IDs in both tables for unique values. I updated so that all are matching now. The table row counts are also the same. I will continue to use the Plaid Sync to see if there will be new transactions and...
  20. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    Okay I have 2 workbooks one before and one after using Plaid Sync. Unfortunately though there aren't any new transactions since yesterday so they seem to be the same.
  21. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    Okay maybe I am not being clear. The raw data comes from the Transactions sheet table (Table1) which will always be adding more transactions by an external code that I cannot control. It is done with what is called Plaid which is a security that gets transactions from banks and credit cards...
  22. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    Yes what happened was the banks changed IDs for the same transactions so please use my latest file. It has all of the transactions but the IDs are different than earlier workbooks.
  23. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    My point now is there are 19 unique transactions between the Transactions sheet and the Notes sheet yet there are only 4 more rows. So there seems to be something weird going on with the data.
  24. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    The 19 unique are between the tables on the Transactions and Notes sheets as you can see in the formulas.
  25. J

    VBA Code to Dynamically Expand Table if Another Table Expands

    What I found interesting is there are 4 more rows yet there are 19 unique IDs.
Back
Top