I have a dataset of 80 samples. Each has 12 attributes (values). I want to extract only four values from each sample. All data is in Column A and the values follow the same order for each sample. I want to extract the values to Column F. I think I could write a macro with the “offset command” and a loop. I want to follow this pattern:
1. Extract value from A1 to F1 (use offset 3 to return to source data and select A4)
2. Extract value from A4 to F2 (use offset 6 to return to source data and select A10)
3. Extract value from A10 to F3 (use offset 1 to return to source data and select A11)
4. Extract value from A11 to F4
5. Leave next two cells in Column F blank
6. Move two cells down in source data to A13
7. Repeat pattern until reaching end of dataset
See attached example dataset with desired results in Column F. Thanks in advance! I am new to VBA.
Bookmarks