Worksheets emulating database 1:many
 

Any advice on how to set up 2 worksheets so that they have the same
first column of data (A:A), but any changes, insertions or deletions
to column A on worksheet 1 will be matched by changes to worksheet 2?

Bit like a database of 2 tables really.

Thanks, Chris

Worksheets emulating database 1:many
 

It's a bit scary to mention -- but what if you "grouped" sh1 and ah2;
anything you do to sh1 gets done to sh2.....
Right

"cjakeman" wrote:

Any advice on how to set up 2 worksheets so that they have the same
first column of data (A:A), but any changes, insertions or deletions
to column A on worksheet 1 will be matched by changes to worksheet 2?

Bit like a database of 2 tables really.

Thanks, Chris