Column A, B and C are automatic (generated from the sheet1), column D an E are not automic
But if I change value in sheet 1 the composition changes in sheet 2. (for example delete/add an age in sheet 1)
The values in column D and E supposed to be coupled to the right ID and age, but because of the movement this is not the case.
How can I make sure that the information in column D and E changes in order, and belongs to the right information of column A B and C en sheet 2. Maybe that is data is sort of coupled?
It is more clear if you look at the excel sheet, especially to sheet 2.
(I do not want to past the comments in sheet 1)
I would be very glad if someone could help me.
Thanks!
Bookmarks