Mike_Bio
12-27-2012, 10:07 PM
I am trying to create a macro to do the following:
Conditions:
workbook1 contains a value in cell A4 with related data in cell D4 i need to copy to a seperate workbook.
Workbook3 contains a list of values in column B that match the value in workbook1 cell A4. The list of values in workbook 3 are unique.
Proceedure:
I need to use the value in workbook1 cell A4 to find the related row of data in workbook3 in column B, then copy workbook1 cell D4 to the related row of data in workbook3 offset from column B by 15 columns.
Any help would be appricaited
Mike
Conditions:
workbook1 contains a value in cell A4 with related data in cell D4 i need to copy to a seperate workbook.
Workbook3 contains a list of values in column B that match the value in workbook1 cell A4. The list of values in workbook 3 are unique.
Proceedure:
I need to use the value in workbook1 cell A4 to find the related row of data in workbook3 in column B, then copy workbook1 cell D4 to the related row of data in workbook3 offset from column B by 15 columns.
Any help would be appricaited
Mike