G
Guest
Hi there.
I have multiple sheets that I need to "join". Using a database, this would
be something like :
table 1
id (PRIMARY KEY)
name
table 2
id
table1_id (FOREIGN KEY)
name
thus table1 and table 2 are joined. I need to do a similar sort of thing in
Excel, so when the "master sheet" is updated, the data in the corresponding
sheets should also be updated accordingly.
Any pointers on how I can set an Excel spreadsheet up to work like this?
Thanks in advance!
Bobby.
I have multiple sheets that I need to "join". Using a database, this would
be something like :
table 1
id (PRIMARY KEY)
name
table 2
id
table1_id (FOREIGN KEY)
name
thus table1 and table 2 are joined. I need to do a similar sort of thing in
Excel, so when the "master sheet" is updated, the data in the corresponding
sheets should also be updated accordingly.
Any pointers on how I can set an Excel spreadsheet up to work like this?
Thanks in advance!
Bobby.