Swap journal

Hi
Does anyone find a swap journal useful? It could be set up similarly to https://en.numista.com/vous/journal.php. Any changes in bigger swaps, if people tend to change already agreed pairs or coins without any notice, are somewhat hard or impossible to follow, unless you take extra length and record every partial agreement. Such swap journal would there for be of extra use in these special swaps with "special people"...
LP

HI
A small extern program in Excel is proposed here : https://en.numista.com/forum/topic82841.html
but it requires having Excel to export at the end of each intervention
while waiting better
CPS

Hi

I am getting an 1004 error, probably due to "Sheets(1).Select" snippet in "Private Sub Workbook_Open". I guess it needs to check whether more than one sheet is open, as "NOTICE" sheet is not the one to be worked on. In case of second sheet, it must be selected, then app needs to have another third sheet (modified swap) in order to check. I cannot do much here as the whole workbook is protected.

Further more "LIG1 = 5" would be better of if the code would recognize lettering as currently set in line 4 (issuer / reference / / ...), so that it sets next line (currently 5th row) as starting point. Sometimes it is good to have such approach, because if Numista changes something in table header or anything else, "LIG1 = 5" snippet does without this check, would be better off to have a warning of a sort.

Have to check the code part ' recherche des différences in more detail to understand what it does exactly. I suppose PREM is first - exported swap table, DERN is modified second - exported swap table.

I am not getting far enough to see what does this part ' présentation de la feuille. I'll copy the VBA code in another workbook to see why it is stopping within second line already...

I would still like such upgrade on Numista, because this app shows differences between two randomly compared swap tables only (not all changes in selected swap - but this cannot be properly settled with outside app anyway).

Still many-many thanks!

Hi,
Thank you very much for your return ! This is an answer I was hoping for.
That's what I like most about Numista : a collaborative site that has been growing for 12 years thanks to the contributions and suggestions of its members and the involvement of many volunteers who have agreed to bring their knowledge to the benefit of all others. According to the principle ‘par et POUR TOUS’ (by and for all).
This feature is part of the 122 + 293 suggestions for improvement, with the 7 + 31 current bug reports (French and English) I think there is more urgent before Numista integrates it into his program.
I am far from being an expert in Excel, I do not hide it, the code progresses empirically as and when it is used. When it seems to me successful I share it and there may still be differences between the one I use and the two available (EN and FR). They are protected precisely to cause reactions by avoiding adjustments that would remain individual and personal.
I contact you by PM. excuse if my english language (and/or other) is bad..
CPS