Hi,
I have one Raw_test file and one Result file. This raw data file contains several different sheets. The sheet that I'm interested in (sheet 'box') has different column names with data starting at row 2. I need only data from 2 columns (column R and column S). The code should be in Result file.
1. To copy data from column R from sheet 'box' in Raw_test file to be pasted to column 'Data' in Consignes sheet in the Result file.
2. To copy the 'Date' column following the rows of the data accordingly, and paste it to 'Date' column in Consignes sheet.
3. Under 'Parameter' column, for data in column R, the parameter should be Togg@ox2 (as specified in Control Panel).
4. Repeat step 1 to 3 for column S (Raw_test file, sheet 'box'), but continue from the empty row after data from column R has been filled in (column S's parameter is Togg@n2, as specified in Control Panel).
I have included an example of data extraction for column R & S (manually done). Can anyone help me to automate the data extraction?
Thanks in advance for the help!
Bookmarks