VBA Code to search list of named tables within a workbook, and SumIF.

[hutch27]

Hi all -

Looking for a starting point here. I have a workbook with a main Summary tab, and multiple other tabs containing named tables. I am looking for a VBA code to search through a mapped list of the named tables and return a value (based on a SumIF formula) from one of the named tables on a separate sheet. Here is some background and an example:

Summary tab - This consists of rows with various general ledger ("GL") account names, each of which has an associated GL Account Number, GL Tab Name, and Table Name in the cells to the right of the preceding item. Here is a table to visualize this Summary tab:

GL Account Name	GL Account Number	GL Tab Name	Table Name	Balance, per supporting tab
Cash	100	Cash Summary	Table_Cash_Summary
Dividend Income	110	Income	Table_Income
Bank Fees	120	Expenses	Table_Expenses

Goal:

1. To create a formula in the Balance, Per Supporting Tab column with the following logic:
   • Using the GL Tab Name (and, if needed, the associated Table Name), sum all values within that table (which are located on each corresponding GL Tab Name sheet) related to that GL Account Number

Thanks!

 

[Fluff]

Duplicate to: How to SUMIF, with the range and sum range dependent on tables located across multiple sheets

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.