I have three sheets. First sheet renamed General:
Dave Henderson 21/05/2014 Elton Rus 22/06/2014 John Smith 20/05/2015
Second sheet renamed Licence:
Forename Surname Licence Dave Henderson Car Elton Rus Bus John Smith HGV
Third sheet renamed Hire date:
Forename Surname Pass date Dave Henderson 29/05/2015 Elton Rus 30/01/2015 John Smith 01/04/2015
The first 2 columns (Forename and Surname) are copied with this formula
to the Licence and Hire date sheets.
The only column left to be filled in is the Licence column (in the first sheet - Licence) and the Pass date (in the second sheet - Hire date). I would like to use only the first sheet to add names and those names should copy into the other sheets. The thing is, when I am trying to sort the Surname in the first sheet (General) everything is mixing into the other sheets.
Is there a chance that I can add names only in the first sheet? After that I'd like those names to copy into the other sheets and not to mix with other sheets when I am trying to sort the names in the first sheet.