mountainman88
Board Regular
- Joined
- Jun 22, 2019
- Messages
- 109
- Office Version
- 2016
- Platform
- Windows
I would like an array that takes this table (i will call it TableA):
<tbody>
</tbody>
<tbody>
</tbody>
(would ideally like a msgbox to ask the sheetname and first cell of where TableA is located)
and turns TableA into a 2d array called 'TableA' where:
Row 1 of the array is the TableA contents sorted as follows:
<tbody>
</tbody>
(Notice any items already in the top row of TableA are ignored and not duplicated when in the format above)
and
Row 2 of the array contains:
- 'total' if the row 1 array item is on the top of TableA eg. 'GrandTotal, Total1 etc'
- 'data' if the row 1 array item is NOT on the top row of TableA
- 'blank' if the row 1 array item is empty (ie left a blank column in TableA) like between stones and Total3
I would like the array to exclude any other 'blanks' eg under Stones or Who. Just include the 'blanks' in the top row of TableA..
The array should look like this:
<tbody>
</tbody>
hope this makes sense, should test you guys ha
GrandTotal | Total1 | Total2 | (empty cell) | Total3 |
Total1 | Apples | Beatles | Cats | |
Total2 | Bananas | Stones | Who | |
Total3 | Cherries |
<tbody>
</tbody>
<tbody>
</tbody>
(would ideally like a msgbox to ask the sheetname and first cell of where TableA is located)
and turns TableA into a 2d array called 'TableA' where:
Row 1 of the array is the TableA contents sorted as follows:
GrandTotal | Total1 | Apples | Bananas | Cherries | Total2 | Beatles | Stones | (empty) | Total3 | Cats | Who |
<tbody>
</tbody>
(Notice any items already in the top row of TableA are ignored and not duplicated when in the format above)
and
Row 2 of the array contains:
- 'total' if the row 1 array item is on the top of TableA eg. 'GrandTotal, Total1 etc'
- 'data' if the row 1 array item is NOT on the top row of TableA
- 'blank' if the row 1 array item is empty (ie left a blank column in TableA) like between stones and Total3
I would like the array to exclude any other 'blanks' eg under Stones or Who. Just include the 'blanks' in the top row of TableA..
The array should look like this:
GrandTotal | Total1 | Apples | Bananas | Cherries | Total2 | Beatles | Stones | (empty) | Total3 | Cats | Who |
Total | Total | Data | Data | Data | Total | Data | Data | Blank | Total | Data | Data |
<tbody>
</tbody>
hope this makes sense, should test you guys ha