Hello,
The image "Output" shows the results of my pasting a bank feed export into a spreadsheet that splits the activity by type (withdrawal, deposit, check) and populates the transactions in alphabetical order by the memo into tables for each transaction type. I think the answer to my question would apply to all transaction types, so please assume I am talking about withdrawals going forward.
Based upon the withdrawal memo (In this case, "W2" of output), I select the necessary vendor, payee, etc. (Cell "T2") from a validated list. This populates "U2" with the correct account (expense, liability, etc.) via a Vlookup to a different table on a different worksheet (table of only vendors in column 1 and accounts in column 2).
I would like to use VBA to search each memo ("F9" of the "Bank Feed" image) for a list of strings (in the example - "Pizza Hut", "Exxon", or "Express Delivery") and return the vendor name in "T2" and the account in "U2" (of the "Output" worksheet).
Once it identifies a match and places that text in column T, I would like it to move to the next memo ("F10" of "Bank Feed") and continue until it reaches the string (full, not partial) "Total" in column A of the "Bank Feed" worksheet (the end of the table).
Is this possible?
Any personal information has been changed (which is why the memos aren't in alphabetical order as previously stated).
Thanks so much in advance.
The image "Output" shows the results of my pasting a bank feed export into a spreadsheet that splits the activity by type (withdrawal, deposit, check) and populates the transactions in alphabetical order by the memo into tables for each transaction type. I think the answer to my question would apply to all transaction types, so please assume I am talking about withdrawals going forward.
Based upon the withdrawal memo (In this case, "W2" of output), I select the necessary vendor, payee, etc. (Cell "T2") from a validated list. This populates "U2" with the correct account (expense, liability, etc.) via a Vlookup to a different table on a different worksheet (table of only vendors in column 1 and accounts in column 2).
I would like to use VBA to search each memo ("F9" of the "Bank Feed" image) for a list of strings (in the example - "Pizza Hut", "Exxon", or "Express Delivery") and return the vendor name in "T2" and the account in "U2" (of the "Output" worksheet).
Once it identifies a match and places that text in column T, I would like it to move to the next memo ("F10" of "Bank Feed") and continue until it reaches the string (full, not partial) "Total" in column A of the "Bank Feed" worksheet (the end of the table).
Is this possible?
Any personal information has been changed (which is why the memos aren't in alphabetical order as previously stated).
Thanks so much in advance.