Dear VBA/Excel Gurus,
I would like to create series of reports based on common values.
As an example:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
So basically, What I would like to achieve would be a VBA coding to produce Workbooks based on the Currency filter:
Example Results:
First Workbook: File Name: EUR.xlsx
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Second Workbook: File Name: RUB.xlsx
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Third Workbook: File Name: XOF.xlsx
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
and so on and so on. Is there any possibility doing this job via excel? It would probably deal with at least 50k rows (the whole report).
Many thanks for ideas, hints and almost anything
Kind regards
Ildestino
I would like to create series of reports based on common values.
As an example:
Continent | Country | City | Currency |
Europe | Austria | Vienna | EUR |
Europe | Russia | Moskau | RUB |
Europe | Germany | Berlin | EUR |
Europe | Belarus | Minsk | RUB |
Africa | Senegal | Dakar | XOF |
Africa | Togo | Lome | XOF |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
So basically, What I would like to achieve would be a VBA coding to produce Workbooks based on the Currency filter:
Example Results:
First Workbook: File Name: EUR.xlsx
Continent | Country | City | Currency |
Europe | Austria | Vienna | EUR |
Europe | Germany | Berlin | EUR |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Second Workbook: File Name: RUB.xlsx
Continent | Country | City | Currency |
Europe | Russia | Moskau | RUB |
Europe | Belarus | Minsk | RUB |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Third Workbook: File Name: XOF.xlsx
Continent | Country | City | Currency |
Africa | Senegal | Dakar | XOF |
Africa | Togo | Lome | XOF |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
and so on and so on. Is there any possibility doing this job via excel? It would probably deal with at least 50k rows (the whole report).
Many thanks for ideas, hints and almost anything
Kind regards
Ildestino