I would like to to created a Excel spreadsheet with two tabs ..One will be a master calander with a place for names and date of hire… used for printing only… would like to link secaond tab with a list of names in column 1 and hire date in column two.. this will be hyperlinked to the master cell f2.. name …but how do I .when it link update the master to match cell name from tab two.
Sheet 1 – cell f2 Name:
Sheet 2
a1- bob smith
b1- tom jonnes
ect link on a1 sheet two and updated sheet one f2 ect …is this possible
