Hi
Option A is what I have on my screen which has 500 rows of data and not all rows have information in columns F G & H, option B is what I'm wishing to achieve. Is there a way of achieving this without VBA, if so would appreciate if you can advise. If VBA is the answer can someone assist. My VBA skills are limited plus I wish to understand what the scripting means so any comments on the scripting would be appreciated.
Thanks Mark
<colgroup><col width="124" style="width:93pt"> <col width="174" style="width:131pt"> <col width="144" style="width:108pt" span="2"> <col width="213" style="width:160pt"> <col width="144" style="width:108pt"> <col width="141" style="width:106pt"> <col width="215" style="width:161pt"> </colgroup><tbody>
</tbody>
Option A is what I have on my screen which has 500 rows of data and not all rows have information in columns F G & H, option B is what I'm wishing to achieve. Is there a way of achieving this without VBA, if so would appreciate if you can advise. If VBA is the answer can someone assist. My VBA skills are limited plus I wish to understand what the scripting means so any comments on the scripting would be appreciated.
Thanks Mark
A | B | C | D | E | F | G | H | |
OPTION A | ||||||||
1 | Relationship Type | Company Name/Last name | Contact 1 - First Name | Contact 1 - Last Name | Contact 1 - Email | Contact 2 - First Name | Contact 2 - Last Name | Contact 2 - Email |
2 | Solicitor | The Law Firm | Fred | Smith | fred.smith@thelawfirm.com.au | John | Brown | john.brown@thelawfirm.com.au |
3 | Accountant | Bean Counter | Criag | Toms | craig.tome@beancounters.com | |||
4 | Real Estate | Hot Property | David | Jones | djones@hotproperty.com.au | Anne | Hayes | anne.hayes@hotproperty.com.au |
OPTION B | ||||||||
1 | Relationship Type | Company Name/Last name | Contact 1 - First Name | Contact 1 - Last Name | Contact 1 - Email | |||
2 | Solicitor | The Law Firm | Fred | Smith | fred.smith@thelawfirm.com.au | |||
3 | Solicitor | The Law Firm | John | Brown | john.brown@thelawfirm.com.au | |||
4 | Accountant | Bean Counter | Criag | Toms | craig.tome@beancounters.com | |||
5 | Real Estate | Hot Property | David | Jones | djones@hotproperty.com.au | |||
6 | Real Estate | Hot Property | Anne | Hayes | anne.hayes@hotproperty.com.au |
<colgroup><col width="124" style="width:93pt"> <col width="174" style="width:131pt"> <col width="144" style="width:108pt" span="2"> <col width="213" style="width:160pt"> <col width="144" style="width:108pt"> <col width="141" style="width:106pt"> <col width="215" style="width:161pt"> </colgroup><tbody>
</tbody>