Linked Tables

[sammyg83]

Hi

I've solved many of my problems searching your forum and youtube, but this one I'm really struggling to find anything for.

Basically I've got 4 tables, one being what I would consider a master table which is a matrix/simplifier of all the other tables.

These tables are all relative to "ID No, Name, Job Title and Location".

Is there a way that I can link the tables, so if I add a name to the bottom of the master list it will add a row for this person onto all tables including all the relative data?

Many thanks

Sam.

[noexcel=badwork]

hi
attached an approach of what you are looking for

[sammyg83]

The formula works great, but when I try it on two named tables, it doesn't add any extra information onto the bottom. It only appears if you physically extend the tables?

[noexcel=badwork]

hi
you can drage vertically to add more column
or horizantally to add more row

[sammyg83]

But there's no way to automatically update the table?

[noexcel=badwork]

may be you need VBA using macro
to accomplish this task
An excel guru may give you one
macro to do this thing