Hi,
I have a master sheet with various columns ie. Team number, Driver, Navigator, Vehicle, Registration number etc. Under each of these there are lots of rows (Teams).
I want to split this master sheet up into different sheets (One for each Team) containing only the information for that team. I know I can paste special and link, but because there are many teams, I was hoping there is an easier way?
Ideally, I would like to just type in the team number, and then get all that team's information in a predefined format. Also, if any information on the master sheet changes, it should update on the individual sheets.
Any help would be appreciated
Thanks
Jo
I have a master sheet with various columns ie. Team number, Driver, Navigator, Vehicle, Registration number etc. Under each of these there are lots of rows (Teams).
I want to split this master sheet up into different sheets (One for each Team) containing only the information for that team. I know I can paste special and link, but because there are many teams, I was hoping there is an easier way?
Ideally, I would like to just type in the team number, and then get all that team's information in a predefined format. Also, if any information on the master sheet changes, it should update on the individual sheets.
Any help would be appreciated
Thanks
Jo