Three columns of a database in another sheet and always updated
HI. I’m new to this forum and I have the following need.
I have a database where I collect student data when they enroll.
I would like three of these data (surname, name and tax code respectively) to also appear in another sheet and to be updated whenever they are modified in the main database.
Furthermore, I would like that by adding or removing some rows in the main database (so if I add or remove some students), the same changes would also occur in the other sheet showing the various surnames, first names and tax codes. I tried with the Power query option but it doesn’t seem to work.
Thank you.
HI. I’m new to this forum and I have the following need.I have a database where I collect student data when they enroll.I would like three of these data (surname, name and tax code respectively) to also appear in another sheet and to be updated whenever they are modified in the main database.Furthermore, I would like that by adding or removing some rows in the main database (so if I add or remove some students), the same changes would also occur in the other sheet showing the various surnames, first names and tax codes. I tried with the Power query option but it doesn’t seem to work.Thank you. Read More