#### rockclimber

##### New Member

- Joined
- Jun 27, 2019

- Messages
- 3

1) Find Keyword 1 on Sheet 1

2) Skip 3 columns and copy a varying number (based on source sheet) of columns with data; below would be 4 columns (111 thru 114) but it could be 3, 10, 20, etc. in total; note that --- is not an empty cell

3) Paste this row on Sheet 2 starting at "C8" thru "[]8" ([] depends on number of cells copied)

4) Find Keyword 2 on Sheet 1

5) Find Subkey 2 and 3 based on location of Keyword 2 (they are always one column right, but variable row)

6) Copy rows Subkey 2 and 3, but only the same columns as 111 thru 114; 4 in total below, so the 4 dates and 211 thru 214 (even the middle --- in this case)

7) Paste these rows in "C9" thru "[]9" and "C10" thru "[]10" on other sheet

Keyword1 | 111 | 112 | 113 | 114 | --- | --- | ||||||

Keyword2 | Subkey1 | 333 | 333 | 333 | 333 | 333 | 333 | |||||

Subkey2 | 1-Oct | 2-Oct | 3-Oct | 4-Oct | --- | --- | ||||||

Subkey3 | 211 | --- | --- | 214 | 215 | 216 | ||||||

<tbody>

</tbody>

I can find the Keywords with .Find but I have no fixed cells to work with, so I'm stuck how to select the data to copy and paste. Thanks again for any ideas you can share!