Ranged data expert help required..

**winfang** · 08-28-2014, 10:56 AM

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

**Solus Rankin** · 08-28-2014, 06:19 PM

How will the category you want to be displayed be selected?

Will multiple categories ever need to be displayed at the same time?

**winfang** · 08-28-2014, 08:26 PM

Hi Solus,I think the Find function is required to grab the range of cells between row with "xxx" and row with "total xxx" as the cell location will keep changing in the column.

Yes there will be multiple categories displayed, at present looking to display 4 categories.