Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Emulating Text to Columns -- Separating Data into Appropriate Colu | Excel Worksheet Functions | |||
emulating if else Like statements with case | Excel Programming | |||
Creating worksheets from a database | Excel Discussion (Misc queries) | |||
Returning Arrays, emulating standard function behavior | Excel Programming | |||
emulating xl consts | Excel Programming |