Hi!
I have a situation where my Excel spreadsheet has become so large and unwieldy that I'd like to have some of its data in one sheet and some in a second sheet. The data can all be connected by a primary key, in this example the license plate of a car. The first sheet will list information about each car (license plate, make, model, colour etc.) while the second sheet will list information about each driver (license plate, first name, last name etc.).
Question: when I insert a new row into sheet one (car) to add a new car to the sheet, how do I make a corresponding row be inserted into sheet 2 (driver) so that the two sheets are in sync with each other? In other words, if alphanumeric sorting places license plate number ABC126 in cell A5 of sheet Car, how do I ensure cell A5 of sheet Driver is also ABC126?
I have an example spreadsheet here.
Thanks in advance for your help!
I have a situation where my Excel spreadsheet has become so large and unwieldy that I'd like to have some of its data in one sheet and some in a second sheet. The data can all be connected by a primary key, in this example the license plate of a car. The first sheet will list information about each car (license plate, make, model, colour etc.) while the second sheet will list information about each driver (license plate, first name, last name etc.).
Question: when I insert a new row into sheet one (car) to add a new car to the sheet, how do I make a corresponding row be inserted into sheet 2 (driver) so that the two sheets are in sync with each other? In other words, if alphanumeric sorting places license plate number ABC126 in cell A5 of sheet Car, how do I ensure cell A5 of sheet Driver is also ABC126?
I have an example spreadsheet here.
Thanks in advance for your help!
