Good afternoon,
I'm trying to get my macro to paste row j from "master" workbook into cell A12 of sheet1 in each workbook j in E:\DIRECTORY\. The files in the directory are sorted in the same order as the rows to be copied in master. Row 1 in master goes to workbook 1 (A12 in sheet1), row 2 in master goes to workbook2 (A12 in sheet 1) etc. Below is my attempt, but it keeps looping through files until every file gets every row. I only want one row per file:
![]()
Please Login or Register to view this content.
Bookmarks