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

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

I appreciate your assistance. Only, I don't think I explained myself clearly
{sorry}. The latest sheet was not copied/moved from the sheet I am working
on. It was given to me in excel, but with different columns. I am
interested primarily in comparing/updating birthdates from the new sheet.

Thanks!

"Ron Coderre" wrote:

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

OK...let's get on the same page here. What I suggested WOULD update your
Mastersheet with the lastest information from the NewDataSheet.

The easiest way (from a description standpoint) was for you to right-click
the tab of the NewDataSheet and create a copy of it in the same workbook as
the Mastersheet. That's what I was referering to in my assumption.

Then just follow my previous instructions. Of course, adjust references to
suit your actual situation. That should update the birtdates of the
Mastesheet with the latest birthdates from the NewDataSheet.

When done...just delete the formulas and the copy of the NewDataSheet.

Does that help?

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


"mlf" wrote:

I appreciate your assistance. Only, I don't think I explained myself clearly
{sorry}. The latest sheet was not copied/moved from the sheet I am working
on. It was given to me in excel, but with different columns. I am
interested primarily in comparing/updating birthdates from the new sheet.

Thanks!

"Ron Coderre" wrote:

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

Thank you so much for your help! It worked.

"Ron Coderre" wrote:

OK...let's get on the same page here. What I suggested WOULD update your
Mastersheet with the lastest information from the NewDataSheet.

The easiest way (from a description standpoint) was for you to right-click
the tab of the NewDataSheet and create a copy of it in the same workbook as
the Mastersheet. That's what I was referering to in my assumption.

Then just follow my previous instructions. Of course, adjust references to
suit your actual situation. That should update the birtdates of the
Mastesheet with the latest birthdates from the NewDataSheet.

When done...just delete the formulas and the copy of the NewDataSheet.

Does that help?

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


"mlf" wrote:

I appreciate your assistance. Only, I don't think I explained myself clearly
{sorry}. The latest sheet was not copied/moved from the sheet I am working
on. It was given to me in excel, but with different columns. I am
interested primarily in comparing/updating birthdates from the new sheet.

Thanks!

"Ron Coderre" wrote:

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

Thanks for letting me know that it worked. I'm glad I could help.


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


"mlf" wrote:

Thank you so much for your help! It worked.

"Ron Coderre" wrote:

OK...let's get on the same page here. What I suggested WOULD update your
Mastersheet with the lastest information from the NewDataSheet.

The easiest way (from a description standpoint) was for you to right-click
the tab of the NewDataSheet and create a copy of it in the same workbook as
the Mastersheet. That's what I was referering to in my assumption.

Then just follow my previous instructions. Of course, adjust references to
suit your actual situation. That should update the birtdates of the
Mastesheet with the latest birthdates from the NewDataSheet.

When done...just delete the formulas and the copy of the NewDataSheet.

Does that help?

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


"mlf" wrote:

I appreciate your assistance. Only, I don't think I explained myself clearly
{sorry}. The latest sheet was not copied/moved from the sheet I am working
on. It was given to me in excel, but with different columns. I am
interested primarily in comparing/updating birthdates from the new sheet.

Thanks!

"Ron Coderre" wrote:

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