Dynamic Tables?

[mafify]

Hey everyone!

Hoping you could help with something.

Any way you can create a dynamic table whereby it populates or reduces rows based on the number of rows added or taken away in another table?

Thanks guys

[MarvinP]

Hi mafify,

It sounds like you need to learn about Dynamic Named Ranges.
https://www.ablebits.com/office-addi...c-named-range/
You could use a DNR in the Names Manager that would be defined by the second table.

If you give an example workbook/worksheet we could show you how.

[sandy666]

use Power Query
if you change anything in source table, then refresh PQ table you'll see changes