Try this:
Assumptions:
Mastersheet has Names in Col_A, DateOfBirth in Col_B
NewDataSheet has been copied/moved to the same workbook as Mastersheet
NewDataSheet has Names in Col_A, DateOfBirth in Col_B

On the Mastersheet:
C2:
IF(ISERROR(VLOOKUP(A2,NewDataSheet!A1:B100,2,0)),B 2,VLOOKUP(A2,NewDataSheet!A1:B100,2,0))

Copy that down as far as needed
(It will use the old value, unless there is a new value in the NewDataSheet)

Then select all of the formulas in Col_C
EditCopy
Select Cell B2
EditPaste SpecialValues


Does that help?

***********
Regards,
Ron


"mlf" wrote:

Hi-

I am working off of a mastersheet with student names, addresses, date of
births, etc. I was recentely given another spreadsheet of some of the
students with their date of births, what would be the easiest way to update
the mastersheet?

Thanks in advance.
mlf