Adriaan_VBA
New Member
- Joined
- Dec 23, 2013
- Messages
- 1
I need to convert a data matrix in Excel to a csv-file and would like to use a VBA for it, as i need to multiple large sheets. I have searched the web but can't find solutions for it. Who can help me out here?
example data matrix i have:
<tbody>
</tbody>
it needs to look like, so I can convert it to a CSV file for uploading it to Salesforce:
<tbody>
</tbody>
Any tips and tricks are helpful
Thanks,
Adriaan
example data matrix i have:
Product 1 | Product 2 | Product 2 | Product 2 | |
volume | price | volume | price | |
Company A | 1000 | 2 | 3000 | 4 |
Company B | 5000 | 6 | 7000 | 8 |
<tbody>
</tbody>
it needs to look like, so I can convert it to a CSV file for uploading it to Salesforce:
Product | Metric | Value | |
Company A | 1 | volume | 1000 |
Company A | 1 | price | 2 |
Company A | 2 | volume | 3000 |
Company A | 2 | price | 4 |
Company B | 1 | volume | 5000 |
Company B | 1 | price | 6 |
Company B | 2 | volume | 7 |
Company B | 2 | price | 8000 |
<tbody>
</tbody>
Any tips and tricks are helpful
Thanks,
Adriaan