Hello,
I am new to VBA and need some help on creating code or using a formula to look at the current sheet A column's rows and look in a different spreadsheet for that same value.
If that value exists, then copy specific row data from the different spreadsheet to the current spreadsheet. For example, Maint Validation sheet has employee id's in columns A2, A3, A4, etc. I would like for those values to be looked at in Sheet Employee Data. If the value is found, the copy specific rows from Sheet Employee Data sheet to Maint Validation sheet.
Is there a formula that can do this? If not has anyone used code to do this? Can you share your code and/or
suggest some code? Any help would be greatly appreciated!!
TIA,
Linda
I am new to VBA and need some help on creating code or using a formula to look at the current sheet A column's rows and look in a different spreadsheet for that same value.
If that value exists, then copy specific row data from the different spreadsheet to the current spreadsheet. For example, Maint Validation sheet has employee id's in columns A2, A3, A4, etc. I would like for those values to be looked at in Sheet Employee Data. If the value is found, the copy specific rows from Sheet Employee Data sheet to Maint Validation sheet.
Is there a formula that can do this? If not has anyone used code to do this? Can you share your code and/or
suggest some code? Any help would be greatly appreciated!!
TIA,
Linda