YUAN_DUMALE
New Member
- Joined
- Oct 23, 2014
- Messages
- 11
Please help on creating a macro for my issue below:
EX:
Copy content of upper row to the next two row if Column "W" has a value of " (Employee + 1 Dependent).
Content of rows to be copied must start from Column "X" moving forward
You can also refer below:
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>
EX:
Copy content of upper row to the next two row if Column "W" has a value of " (Employee + 1 Dependent).
Content of rows to be copied must start from Column "X" moving forward
You can also refer below:
| Benefit Name | Core Entitlement | Plan Selected | Benefit Effective Date (mmm/dd/yy) | Dependent Code (Dep 1) | Certificate No. / HKID Card No. (Dep 1) | Surname (Dep 1) | Given Name (Dep 1) | Date of Birth (Dep 1) | Sex (Dep 1) |
| Medical Insurance (Hong Kong) | Core (Employee Only) | Core (Employee + 1 Dependent) | Jul/01/15 | Spouse | D006816(1) | Tamm | Raymond Paul | Sep/07/52 | Male |
| Health Assessment (Hong Kong) | #REF! | Health Assessment (Employee + 1 Dependent) | Jul/01/15 | ||||||
| Dental (Hong Kong) | Dental Insurance (Employee Only) | Jul/01/15 |
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>
| Thank you so much in advance | |||||||||
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>
