I would like to include in the "GEONAMES" file a macro (with the start button in cell "1I", with the text in the file in this cell), the hyperlink to cells in column "D" with excel files contained in the "GEONAMES - FILE EXCEL" folder.
Then, I need two more macros:
1) one that extracts from each excel file, the name of the capital (column "I" of the "GEONAMES" file. This must start with the "I3" cell button.
2) a macro that calculates the number of times that the "GEONAMES" file for the "excel file" in the "GEONAMES - FILE EXCEL" folder is repeated (from the "4" line from the "j" column). This macro must start with a button at the cell "I2".
For point 2) I inserted an excel page "IT" and I put in the formulas to understand what I would like. If you know in the "GEONAMES" column from the "J" column to the "R" column the values to be counted are in column 2G "of the excel files, while from the" S2 "column the values to be counted are in column" H " of each excel file.
Thank you
link:
https://www.dropbox.com/s/17w2e3rbt6ce4rz/macro hyperlink and other.rar?dl=0
Then, I need two more macros:
1) one that extracts from each excel file, the name of the capital (column "I" of the "GEONAMES" file. This must start with the "I3" cell button.
2) a macro that calculates the number of times that the "GEONAMES" file for the "excel file" in the "GEONAMES - FILE EXCEL" folder is repeated (from the "4" line from the "j" column). This macro must start with a button at the cell "I2".
For point 2) I inserted an excel page "IT" and I put in the formulas to understand what I would like. If you know in the "GEONAMES" column from the "J" column to the "R" column the values to be counted are in column 2G "of the excel files, while from the" S2 "column the values to be counted are in column" H " of each excel file.
Thank you
link:
https://www.dropbox.com/s/17w2e3rbt6ce4rz/macro hyperlink and other.rar?dl=0