I need to create a new workbook (or several workbooks) with the data showed in the attached file: "WOKBOOK DATA".
The goal is to create a single sheet (Or workbook) for EACH row with information from WORKBOOK DATA (starting at row 7) with the format that you could see in the other attached file here called "RESULT".
WORKBOOK DATA contains in Row 6 the Titles that Must go in column A in the RESULT file... and the information located in row 7 at WORKBOOK DATA (and next rows) must go in column B.
The simple file RESULT has the target range, where the information must go, highligthed in yellow.
I appreciatte your help and time,