myCOLLECTION + myCOUNTRIES Exports

Exporting its collection allows to have the list of its parts with all its characteristics, up to 24 columns whose access to the Numista sheet of each room, the possibility to ungroup columns and / or to filter by distinguishing criteria (diameter , state, year, etc, etc ...).
In addition, for those interested in more than one country,
The list of Countries / Transmitters may allow you to distinguish between those that do not have a coin and the number of coins in a collection of those already filled.
The reconciliation of these two lists can prove useful in the presentation of its collection as in the elaboration of exchange negotiations.
File as free download .(xlsm compatible)
It provides the list of your coins by country in collection, distinguishing doubles and their number,
the possibility of classifying them by characteristics of format, quality, value, etc., thanks to the filters on each column.
the sheet can be integrated into a binder, as used and illustrated below
(screenshot of the French version)

contact me if you find any problems

For the benefit of a greater number, would there be volunteers to adapt it to OpenOffice or LibreOffice users ?
Thanks for them !

Available again after a period of development during lost time.

I'm sorry, but I don't know how to make it work. Can you give more detailed instructions on the first steps? Thank you.

This is the most complicated part but we don't do it often, except when new transmitters appear that we are interested in.

1- In the "My coins" page click on "View the country list with my collection quantities"


2- Develop the sub-sections that interest you by clicking on the ► example: Argentina.

3- Place the cursor in front of "Countries." and bring it down while keeping the left mouse button pressed to select a few lines. Selecting “Countries” is used to check the clipboard.
Release the button and place the cursor after the last country that interests you (*)
Pressing the ALT key and left-clicking selects the entire area to be copied.

You just have to do CTRL + C and click on the green button of the Excel sheet and YES.
(*) If you only want a few countries, you can delete the rows of countries you don't need in the Excel sheet. Me I develop all.

good ? (with ImTranslator)

It's free without any consideration, so we use it discreetly, and we don't say anything … especially if there is a problem! ..
It is not nice for you or for others.
ONE member reported the bug to me. We were able to find that there were at least 26 versions of Excel worldwide
with VBA instructions that differ from one language to another.
Here is the English version : myCountries_3EN.xls

A message may be displayed to adapt it to your language.