Values in columns to copy separately

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!

Thanks for this!

I tried to play around with your code, by adding in feature to allow user to choose the Raw_test file themselves but I got this error: 'Run-time error '9': subscript out of range'.

Please Login or Register  to view this content.

May I know which part that I did wrong?

Please Login or Register  to view this content.

Hi, jindon

Thanks for this! The other users tried to use this but they kept having error "Method 'Open' of object '_Connection' failed". Tried contacting our IT team to help but they are not helping much so I was thinking to avoid using ADODB as I cannot pinpoint the issue. Is it possible to have the code some other way?

Thank you once again!

Then simply

Please Login or Register  to view this content.