Hi, i currently maintain two tabs in my spreadsheet, one with a list of accounts (named source), and a display tab to list the accounts that falls under the respective category.

In my example spreadsheet attached, the AGE list is supposed to list the range of accounts from between the rows "AGE" and "Total AGE".

I would like to incorporate a dynamic macro which reads the range of the Source data, create the number of rows (based on the lines of the category), listing the accounts in the Display tab.

Given that the source data of the list of accounts under each category will keep changing (plus or minus), it makes it a little tricky to do a plain offset.

Appreciate any help out there, thanks!rangelookup.xlsx