rockclimber
New Member
- Joined
- Jun 27, 2019
- Messages
- 3
Hi, thanks in advance for any help, I realize it's a lot. I'm trying to take one sheet and upload data to another. The task is:
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
<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!
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!