hello , i want to link columns in many workbooks such that every workbook has a name column and a salary column , when i update the salary in a cell in the same row with a name in the first workbook i want it to be updated in all the rows in all workbooks that contains that name , any idea how can this be done even by macros or some vb script ?