Related Posts
Penn or draftkings?
Oh lawd gimmie the strength

Additional Posts in Excel Genius
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Penn or draftkings?
Oh lawd gimmie the strength

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

It sounds like VLOOKUPs or INDEX MATCH MATCH (best practice) might serve you well here. You can put a specific date into cell A1 of the master sheet for example. Then VLOOKUP(A1, Range on ST Sheet, # of rows on ST sheet, 0) to pull data for that month from the ST sheet. You can do something similar for the others.
...cont. and outstanding loan balances.
To build on this, you can also reference the exact tab names in a row or column. SUMPRODUCT, INDIRECT, and SUMIF can pull the corresponding data by month as stated above from each table at its respective tab.
See below -
=SUMPRODUCT(SUMIF(INDIRECT("'"&sheets&"'!"&"rng"),criteria,INDIRECT("'"&sheets&"'!"&"sumrng")))
We’ve used this same formula before for the exact same reason this past year for a client with around 100 separate amortization tables. Also, if the data ranges are transposed, you may want to use OFFSET in there as well.