I need to figure out how to write a macro that does the following:
1. Select the third sheet in the first workbook.
2. In the first workbook, set range j2 as the value to look for.
3. copy all of the data from the third sheet in the first workbook.
4. In the second workbook, search every worksheet for the current value of j2.
5. Once the value is found, paste the previously copied data into cell N2 of that worksheet only.
6. Go back to the first worksheet, advance to the fourth sheet and repeat steps 2- 5 until the last worksheet in the first workbook is selected.
Please let me know how to approach this.
1. Select the third sheet in the first workbook.
2. In the first workbook, set range j2 as the value to look for.
3. copy all of the data from the third sheet in the first workbook.
4. In the second workbook, search every worksheet for the current value of j2.
5. Once the value is found, paste the previously copied data into cell N2 of that worksheet only.
6. Go back to the first worksheet, advance to the fourth sheet and repeat steps 2- 5 until the last worksheet in the first workbook is selected.
Please let me know how to approach this.
