Dear Friends,
Please help me to solve the following task:
DataTable
<tbody>
</tbody>
The key goal is copy the data (Red figures from Column I) to the respective column and rows in the D column ("?" sign cells).
Key issue: there might be more additional rows inserted or deleted before and after My KeyCells (so we cannot fix the code around these cells as they are dynamic)
My suggestion:
Create VBA Macros to perform following actions:
Message bOX - "Done"
Problem: cannot code this idea. Any ideas, Friends?
Or what is your suggestion?
Please help me to solve the following task:
DataTable
| A | B | C | D | E | F | G | H | I | K |
| SomeName | xyz | xyz | |||||||
| SomeName | xyz | xyz | xyz | xyz | |||||
| MyCell | |||||||||
| SomeName a | xyz | ? | xyz | 12 | |||||
| SomeName | xyz | ? | 23 | ||||||
| ? | 3 | ||||||||
| ? | 52 | ||||||||
| ? | 85 | ||||||||
| SomeName Z | ? | 145 |
<tbody>
</tbody>
The key goal is copy the data (Red figures from Column I) to the respective column and rows in the D column ("?" sign cells).
Key issue: there might be more additional rows inserted or deleted before and after My KeyCells (so we cannot fix the code around these cells as they are dynamic)
My suggestion:
Create VBA Macros to perform following actions:
- Find the cell named "XYZ"
- Assign a name to this Cell - MyCell
- Find the range of the targeted cells -(MyCell (+1, +X) (input data)
- Find the range of the targeted cells -(MyCell (+1, +Z) (data to be Copied there - TaRGET LOcation)
- Copy-Paste as Values from INPUT DATA to TARGET LOCATION
Message bOX - "Done"
Problem: cannot code this idea. Any ideas, Friends?
Or what is your suggestion?
