I am trying to code my master workbook to open 6 different workbooks and copy the range on the first worksheet of each of the six sheets and copy the columns of data across sheet 1 of my master workbook. My first error says it can not find the first filename in my directory I am copying from.
And will this code put the data in the next empty column on the master workbook. Please tell me what I am doing wrong with my code. Thank you very much. Ken Mc

Please Login or Register  to view this content.