Hello. I have a question regarding vba.
I want to copy cell values 09, 011 and O13 of workbook A, to column D, J and K of workbook B. First I need to find cell value O7 (workbook A) in column A of workbook B. The copied data needs to fill the blank cells of workbook B.
For example, number 11023 can be found in cell number A20. So D20, J20 and K20 need the new data.
I managed to copy paste values to workbook B, but I'm stuck at finding the correct row.
Thank you!
I want to copy cell values 09, 011 and O13 of workbook A, to column D, J and K of workbook B. First I need to find cell value O7 (workbook A) in column A of workbook B. The copied data needs to fill the blank cells of workbook B.
For example, number 11023 can be found in cell number A20. So D20, J20 and K20 need the new data.
I managed to copy paste values to workbook B, but I'm stuck at finding the correct row.
Thank you!