very stange to select item in web dropdown and click on "cerca"

sal21 · Dec 5, 2022

based this url.

Popolazione residente

demo.istat.it

first...

1) select, vista territoriale
2) flag on, "tutti i comuni della provincia selezionata"
3) Select first value in dropdown
4) click on Cerca

in this case the web show the related table of provincia

i need to make the operation for all item are in dropdown.

Automatrix · Dec 5, 2022

Sounds like a job for Power Automate, if you have access to that.

sal21 · Dec 5, 2022

Automatrix said:
Sounds like a job for Power Automate, if you have access to that.

Power Automate ???

Automatrix · Dec 5, 2022

Power Automate | Microsoft Power Platform

If you don't have access to this (probably via your employer), you can use an open source alternative such as UI.Vision.

sal21 · Dec 6, 2022

Automatrix said:
Power Automate | Microsoft Power Platform

If you don't have access to this (probably via your employer), you can use an open source alternative such as UI.Vision.

TKS, bro.

i have resolved with code:

VBA Code:

Option Explicit
Sub PROVA()
    
    Dim IE As Object, T As Integer, Title As Object
    Dim oHtml As HTMLDocument, post As Object
    
    Clear_Cache
    
    Set IE = CreateObject("internetexplorer.application")
    
    'CreateObject("Shell.Application").ShellExecute "microsoft-edge:https://demo.istat.it/app/?i=POS&l=it"
    
    With IE
        
        .Visible = True
        .navigate "https://demo.istat.it/app/?i=POS&l=it"
        
        Do While .Busy
            DoEvents
        Loop
        
        Do While .readyState <> 4
            DoEvents
        Loop
        
        'CLICK SU VISTRA TERRITORIALE
        .document.getElementById("tab-1").Click
        
        'CHEKBOX TUTTI I COMUNI
        .document.all("territorio")(3).Checked = True
        
        'SELEZIONO UN ITEM PROVINCIA NEL COMBOBOX
        Set Title = .document.getElementById("province-1")
        
        'CONTO E PRENDO IL NOME DELLE PROVINCE NEL COMBOBOX
        Set oHtml = .document
        For Each post In oHtml.getElementById("province-1").getElementsByTagName("OPTION")
            'Debug.Print T & "-" & post.innerText
            T = T + 1
        Next
        
        Title.selectedIndex = 105
        
        'CLICK CERCA
        .document.getElementById("btnricerca-1").Click
        
    End With
    
    IE.Quit
    Set IE = Nothing
    
End Sub

But why the ie object dont show the table of result!!!!

to be sure i have tested this step by step on chrome, edge and firefox, the table of result is show!

Automatrix · Dec 6, 2022

Can't help with VBA, I'm afraid.

John_w · Dec 6, 2022

You could do this with Power Query.

Use your browser tools to view the network requests for one of the provinces, for example Agrigento. The browser sends a POST request to https://demo.istat.it/app/RPCCerca.php, with the following form data:

territorio=procom&province=084&hid-i=POS&hid-a=2022&hid-l=it&hid-cat=POS&hid-dati=dati-form-1&hid-tavola=tavola-form-1

The "084" is the province code for Agrigento, which comes from the dropdown (select element):

HTML:

<select class="w3-select" name="province" id="province-1" title="Seleziona la provincia" required="">
<option value="084">Agrigento</option>
<option value="006">Alessandria</option>

In PQ, add a blank query and in the Advanced Editor, replace the query code with:

Power Query:

let
    url = "https://demo.istat.it/app/RPCCerca.php",
    body  = "territorio=procom&province=084&hid-i=POS&hid-a=2022&hid-l=it&hid-cat=POS&hid-dati=dati-form-1&hid-tavola=tavola-form-1",
    Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content = Text.ToBinary(body) ] )),
    datatable = Source[datatable],
    #"Converted to Table" = Record.ToTable(datatable),
    Value = #"Converted to Table"{0}[Value],
    #"Converted to Table1" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table1", "Column1", {"codistat", "mtot", "ftot", "totmf"}, {"codistat", "mtot", "ftot", "totmf"})
in
    #"Expanded Column1"

Close and Load the query and it returns 43 rows of data to the sheet.

Next, based on that code, create a custom function which accepts a parameter for the province code and invoke it for all the rows in a table of province names and codes.

sal21 · Dec 6, 2022

John_w said:
You could do this with Power Query.

Use your browser tools to view the network requests for one of the provinces, for example Agrigento. The browser sends a POST request to https://demo.istat.it/app/RPCCerca.php, with the following form data:

territorio=procom&province=084&hid-i=POS&hid-a=2022&hid-l=it&hid-cat=POS&hid-dati=dati-form-1&hid-tavola=tavola-form-1

The "084" is the province code for Agrigento, which comes from the dropdown (select element):

HTML:

<select class="w3-select" name="province" id="province-1" title="Seleziona la provincia" required=""> <option value="084">Agrigento</option> <option value="006">Alessandria</option>

In PQ, add a blank query and in the Advanced Editor, replace the query code with:

Power Query:

let url = "https://demo.istat.it/app/RPCCerca.php", body = "territorio=procom&province=084&hid-i=POS&hid-a=2022&hid-l=it&hid-cat=POS&hid-dati=dati-form-1&hid-tavola=tavola-form-1", Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content = Text.ToBinary(body) ] )), datatable = Source[datatable], #"Converted to Table" = Record.ToTable(datatable), Value = #"Converted to Table"{0}[Value], #"Converted to Table1" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table1", "Column1", {"codistat", "mtot", "ftot", "totmf"}, {"codistat", "mtot", "ftot", "totmf"}) in #"Expanded Column1"

Close and Load the query and it returns 43 rows of data to the sheet.

Next, based on that code, create a custom function which accepts a parameter for the province code and invoke it for all the rows in a table of province names and codes.

WOW!
but not for me to create a function code, can you help me?

John_w · Dec 7, 2022

sal21 said:
WOW!
but not for me to create a function code, can you help me?

Ok, I'll try to guide you through the steps to get the data for multiple provinces. Power Query is relatively new to me so some steps might not be optimum.

1. First, create the following table on a sheet and rename it Provinces.



Code	Province
084	Agrigento
006	Alessandria
042	Ancona

The Code column is formatted as Text, and I had to type in the leading zeroes to make all the codes 3 digits long. For this guide, the Provinces table contains only 3 provinces but you can easily expand it to all the provinces.

2. Note - you could skip steps 2 and 3 and go directly to step 4 by creating a blank connection-only query named GetProvinceData, but here I will show you all the individual manual steps needed to get to the web data.

Next, create the basic query which sends a POST request for the province with code 084:

Data tab -> Get Data -> Other sources -> Blank Query. In Advanced Editor, replace everything with:

Power Query:

let
    url = "https://demo.istat.it/app/RPCCerca.php",
    body  = "territorio=procom&province=084&hid-i=POS&hid-a=2022&hid-l=it&hid-cat=POS&hid-dati=dati-form-1&hid-tavola=tavola-form-1",
    Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content = Text.ToBinary(body) ] ))
in
    Source

Click Done to close Advanced Editor.

3. Now we will drill down to the required data, which is in JSON format.

Click Record next to datatable.
Click List next to data.
Click To Table on the Transform tab. Click OK in the To Table dialogue.
Click the Expand icon at the top of Column1.
Select 5 columns: codistat, denominazione, mtot, ftot, totmf. Untick 'Use original column name as prefix'. Click OK.
Under Properties, change the name of the query from Query1 to GetProvinceData.
Click Advanced Editor to view the PQ code, which should be:

Power Query:

let
    url = "https://demo.istat.it/app/RPCCerca.php",
    body  = "territorio=procom&province=084&hid-i=POS&hid-a=2022&hid-l=it&hid-cat=POS&hid-dati=dati-form-1&hid-tavola=tavola-form-1",
    Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content = Text.ToBinary(body) ] )),
    datatable = Source[datatable],
    data = datatable[data],
    #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"codistat", "denominazione", "mtot", "ftot", "totmf"}, {"codistat", "denominazione", "mtot", "ftot", "totmf"})
in
    #"Expanded Column1"

Click Done to close Advanced Editor.
Click Close & Load To...
Important: Click Only Create Connection. This creates a connection-only query named GetProvinceData.

4. Now change the GetProvinceData query to a custom function which accepts a parameter for the province code:

Edit the GetProvinceData query and in Advanced Editor replace everything with:

Power Query:

let GetProvinceData = (ProvinceCode as text) =>
    let
        url = "https://demo.istat.it/app/RPCCerca.php",
        body  = "territorio=procom&province="&ProvinceCode&"&hid-i=POS&hid-a=2022&hid-l=it&hid-cat=POS&hid-dati=dati-form-1&hid-tavola=tavola-form-1",
        Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content = Text.ToBinary(body) ] )),
        datatable = Source[datatable],
        data = datatable[data],
        #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
        #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"codistat", "denominazione", "mtot", "ftot", "totmf"}, {"codistat", "denominazione", "mtot", "ftot", "totmf"})
    in
        #"Expanded Column1"
in GetProvinceData

The changes to the previous PQ code are to 'embed' the let url .... in #Expanded Column1" structure inside the let GetProvinceData ..... in GetProvinceData structure, with the (ProvinceCode as text) parameter and concatenating the ProvinceCode parameter in the body string, replacing the 084 value.

5. Next, we will invoke the GetProvinceData custom function on each row in the Provinces table to return the data for all 3 provinces.

Select a cell in the Provinces table.
Data tab -> From Table/Range.
Important: In the PQ Editor, change the data type of the Code column to Text (Replace current). For some reason, PQ doesn't recognise that the Excel column is formatted as Text.
On the Add Column tab, click Invoke Custom Function.
In the Invoke Custom Function dialogue, choose GetProvinceData in the Function query dropdown. In the ProvinceCode dropdown, choose Code. Click OK.
If displayed, click Continue on the yellow privacy warning and tick 'Ignore Privacy Levels Checks for this file....' and click Save.
Click the Expand icon next to the GetProvinceData column. Select all 5 columns (codistat, denominazione, mtot, ftot, totmf) and untick 'Use original column name as prefix'.
On the Home tab, click Close & Load To... Choose Table option, and select the destination cell and worksheet for the new table.

The query returns 277 rows for the 3 provinces:



Code	Province	codistat	denominazione	mtot	ftot	totmf
084	Agrigento	084001	Agrigento	27188	28448	55636
084	Agrigento	084002	Alessandria della Rocca	1207	1293	2500
084	Agrigento	084003	Aragona	4220	4523	8743
084	Agrigento	084004	Bivona	1578	1648	3226
084	Agrigento	084005	Burgio	1214	1290	2504
084	Agrigento	084006	Calamonaci	578	595	1173
084	Agrigento	084007	Caltabellotta	1527	1694	3221
084	Agrigento	084008	Camastra	938	977	1915
084	Agrigento	084009	Cammarata	2920	2946	5866
084	Agrigento	084010	Campobello di Licata	4409	4684	9093
084	Agrigento	084011	Canicattì	16573	17771	34344
084	Agrigento	084012	Casteltermini	3521	3825	7346
084	Agrigento	084013	Castrofilippo	1211	1386	2597
084	Agrigento	084014	Cattolica Eraclea	1620	1687	3307
084	Agrigento	084015	Cianciana	1460	1639	3099
084	Agrigento	084016	Comitini	430	457	887
084	Agrigento	084017	Favara	15290	16311	31601
084	Agrigento	084018	Grotte	2452	2771	5223
084	Agrigento	084019	Joppolo Giancaxio	498	563	1061
084	Agrigento	084020	Lampedusa e Linosa	3307	3053	6360
084	Agrigento	084021	Licata	16840	17501	34341
084	Agrigento	084022	Lucca Sicula	845	884	1729
084	Agrigento	084023	Menfi	5674	6073	11747
084	Agrigento	084024	Montallegro	1161	1208	2369
084	Agrigento	084025	Montevago	1328	1385	2713
084	Agrigento	084026	Naro	3376	3601	6977
084	Agrigento	084027	Palma di Montechiaro	10134	11117	21251
084	Agrigento	084028	Porto Empedocle	7575	7911	15486
084	Agrigento	084029	Racalmuto	3650	3862	7512
084	Agrigento	084030	Raffadali	5840	6300	12140
084	Agrigento	084031	Ravanusa	5060	5393	10453
084	Agrigento	084032	Realmonte	2146	2225	4371
084	Agrigento	084033	Ribera	8596	9275	17871
084	Agrigento	084034	Sambuca di Sicilia	2667	2718	5385
084	Agrigento	084035	San Biagio Platani	1339	1539	2878
084	Agrigento	084036	San Giovanni Gemini	3728	3804	7532
084	Agrigento	084037	Santa Elisabetta	1032	1105	2137
084	Agrigento	084038	Santa Margherita di Belice	2908	3096	6004
084	Agrigento	084039	Sant'Angelo Muxaro	546	610	1156
084	Agrigento	084040	Santo Stefano Quisquina	1987	2151	4138
084	Agrigento	084041	Sciacca	18974	20141	39115
084	Agrigento	084042	Siculiana	2007	2071	4078
084	Agrigento	084043	Villafranca Sicula	647	695	1342
006	Alessandria	006001	Acqui Terme	8888	10114	19002
006	Alessandria	006002	Albera Ligure	170	145	315
006	Alessandria	006003	Alessandria	44063	46924	90987
006	Alessandria	006004	Alfiano Natta	364	365	729
006	Alessandria	006005	Alice Bel Colle	384	327	711
006	Alessandria	006007	Altavilla Monferrato	216	183	399
006	Alessandria	006008	Alzano Scrivia	183	164	347
006	Alessandria	006009	Arquata Scrivia	3041	3215	6256
006	Alessandria	006010	Avolasca	127	126	253
006	Alessandria	006011	Balzola	623	641	1264
006	Alessandria	006012	Basaluzzo	1012	993	2005
006	Alessandria	006013	Bassignana	764	782	1546
006	Alessandria	006014	Belforte Monferrato	258	240	498
006	Alessandria	006015	Bergamasco	343	366	709
006	Alessandria	006016	Berzano di Tortona	76	81	157
006	Alessandria	006017	Bistagno	869	887	1756
006	Alessandria	006018	Borghetto di Borbera	971	946	1917
006	Alessandria	006019	Borgoratto Alessandrino	253	283	536
006	Alessandria	006020	Borgo San Martino	673	680	1353
006	Alessandria	006021	Bosco Marengo	1154	1097	2251
006	Alessandria	006022	Bosio	546	509	1055
006	Alessandria	006023	Bozzole	162	143	305
006	Alessandria	006024	Brignano-Frascata	216	206	422
006	Alessandria	006025	Cabella Ligure	248	227	475
006	Alessandria	006026	Camagna Monferrato	227	241	468
006	Alessandria	006027	Camino	381	353	734
006	Alessandria	006028	Cantalupo Ligure	222	232	454
006	Alessandria	006029	Capriata d'Orba	888	881	1769
006	Alessandria	006030	Carbonara Scrivia	547	551	1098
006	Alessandria	006031	Carentino	165	156	321
006	Alessandria	006032	Carezzano	209	215	424
006	Alessandria	006033	Carpeneto	462	449	911
006	Alessandria	006034	Carrega Ligure	52	36	88
006	Alessandria	006035	Carrosio	261	233	494
006	Alessandria	006036	Cartosio	349	371	720
006	Alessandria	006037	Casal Cermelli	574	606	1180
006	Alessandria	006038	Casaleggio Boiro	185	185	370
006	Alessandria	006039	Casale Monferrato	15429	17091	32520
006	Alessandria	006040	Casalnoceto	489	478	967
006	Alessandria	006041	Casasco	62	59	121
006	Alessandria	006043	Cassine	1424	1395	2819
006	Alessandria	006044	Cassinelle	444	407	851
006	Alessandria	006045	Castellania	48	40	88
006	Alessandria	006046	Castellar Guidobono	202	196	398
006	Alessandria	006047	Castellazzo Bormida	2186	2239	4425
006	Alessandria	006048	Castelletto d'Erro	62	73	135
006	Alessandria	006049	Castelletto d'Orba	902	934	1836
006	Alessandria	006050	Castelletto Merli	233	217	450
006	Alessandria	006051	Castelletto Monferrato	719	710	1429
006	Alessandria	006052	Castelnuovo Bormida	296	316	612
006	Alessandria	006053	Castelnuovo Scrivia	2372	2491	4863
006	Alessandria	006054	Castelspina	196	196	392
006	Alessandria	006055	Cavatore	119	141	260
006	Alessandria	006056	Cella Monte	237	230	467
006	Alessandria	006057	Cereseto	206	189	395
006	Alessandria	006058	Cerreto Grue	149	153	302
006	Alessandria	006059	Cerrina Monferrato	637	667	1304
006	Alessandria	006060	Coniolo	230	215	445
006	Alessandria	006061	Conzano	475	477	952
006	Alessandria	006062	Costa Vescovato	165	151	316
006	Alessandria	006063	Cremolino	500	495	995
006	Alessandria	006065	Denice	83	87	170
006	Alessandria	006066	Dernice	88	92	180
006	Alessandria	006067	Fabbrica Curone	286	302	588
006	Alessandria	006068	Felizzano	1044	1071	2115
006	Alessandria	006069	Fraconalto	162	140	302
006	Alessandria	006070	Francavilla Bisio	255	251	506
006	Alessandria	006071	Frascaro	214	235	449
006	Alessandria	006072	Frassinello Monferrato	225	245	470
006	Alessandria	006073	Frassineto Po	663	693	1356
006	Alessandria	006074	Fresonara	325	298	623
006	Alessandria	006075	Frugarolo	901	984	1885
006	Alessandria	006076	Fubine Monferrato	770	808	1578
006	Alessandria	006077	Gabiano	522	495	1017
006	Alessandria	006078	Gamalero	382	434	816
006	Alessandria	006079	Garbagna	301	313	614
006	Alessandria	006081	Gavi	2188	2244	4432
006	Alessandria	006082	Giarole	311	359	670
006	Alessandria	006083	Gremiasco	148	143	291
006	Alessandria	006084	Grognardo	119	102	221
006	Alessandria	006085	Grondona	228	248	476
006	Alessandria	006086	Guazzora	146	148	294
006	Alessandria	006087	Isola Sant'Antonio	331	311	642
006	Alessandria	006088	Lerma	380	421	801
006	Alessandria	006090	Malvicino	35	44	79
006	Alessandria	006091	Masio	644	612	1256
006	Alessandria	006092	Melazzo	616	626	1242
006	Alessandria	006093	Merana	93	92	185
006	Alessandria	006094	Mirabello Monferrato	602	605	1207
006	Alessandria	006095	Molare	951	1047	1998
006	Alessandria	006096	Molino dei Torti	303	261	564
006	Alessandria	006097	Mombello Monferrato	441	480	921
006	Alessandria	006098	Momperone	104	91	195
006	Alessandria	006099	Moncestino	92	103	195
006	Alessandria	006100	Mongiardino Ligure	82	72	154
006	Alessandria	006101	Monleale	275	277	552
006	Alessandria	006102	Montacuto	132	119	251
006	Alessandria	006103	Montaldeo	108	124	232
006	Alessandria	006104	Montaldo Bormida	309	296	605
006	Alessandria	006105	Montecastello	143	147	290
006	Alessandria	006106	Montechiaro d'Acqui	259	241	500
006	Alessandria	006107	Montegioco	151	133	284
006	Alessandria	006108	Montemarzino	158	152	310
006	Alessandria	006109	Morano sul Po	637	669	1306
006	Alessandria	006110	Morbello	202	186	388
006	Alessandria	006111	Mornese	339	369	708
006	Alessandria	006112	Morsasco	292	313	605
006	Alessandria	006113	Murisengo	621	661	1282
006	Alessandria	006114	Novi Ligure	13180	14262	27442
006	Alessandria	006115	Occimiano	592	654	1246
006	Alessandria	006116	Odalengo Grande	207	201	408
006	Alessandria	006117	Odalengo Piccolo	124	115	239
006	Alessandria	006118	Olivola	54	60	114
006	Alessandria	006119	Orsara Bormida	198	202	400
006	Alessandria	006120	Ottiglio	296	296	592
006	Alessandria	006121	Ovada	5187	5661	10848
006	Alessandria	006122	Oviglio	588	604	1192
006	Alessandria	006123	Ozzano Monferrato	681	677	1358
006	Alessandria	006124	Paderna	101	97	198
006	Alessandria	006125	Pareto	279	237	516
006	Alessandria	006126	Parodi Ligure	315	295	610
006	Alessandria	006127	Pasturana	613	670	1283
006	Alessandria	006128	Pecetto di Valenza	576	576	1152
006	Alessandria	006129	Pietra Marazzi	417	447	864
006	Alessandria	006131	Pomaro Monferrato	144	162	306
006	Alessandria	006132	Pontecurone	1724	1688	3412
006	Alessandria	006133	Pontestura	634	668	1302
006	Alessandria	006134	Ponti	279	263	542
006	Alessandria	006135	Ponzano Monferrato	155	159	314
006	Alessandria	006136	Ponzone	527	473	1000
006	Alessandria	006137	Pozzol Groppo	152	143	295
006	Alessandria	006138	Pozzolo Formigaro	2269	2238	4507
006	Alessandria	006139	Prasco	241	237	478
006	Alessandria	006140	Predosa	922	964	1886
006	Alessandria	006141	Quargnento	649	689	1338
006	Alessandria	006142	Quattordio	733	766	1499
006	Alessandria	006143	Ricaldone	319	292	611
006	Alessandria	006144	Rivalta Bormida	677	700	1377
006	Alessandria	006145	Rivarone	229	162	391
006	Alessandria	006146	Roccaforte Ligure	74	49	123
006	Alessandria	006147	Rocca Grimalda	740	685	1425
006	Alessandria	006148	Rocchetta Ligure	119	99	218
006	Alessandria	006149	Rosignano Monferrato	698	757	1455
006	Alessandria	006150	Sala Monferrato	163	177	340
006	Alessandria	006151	Sale	1901	2002	3903
006	Alessandria	006152	San Cristoforo	258	281	539
006	Alessandria	006153	San Giorgio Monferrato	583	618	1201
006	Alessandria	006154	San Salvatore Monferrato	2003	2040	4043
006	Alessandria	006155	San Sebastiano Curone	247	280	527
006	Alessandria	006156	Sant'Agata Fossili	175	192	367
006	Alessandria	006157	Sardigliano	186	200	386
006	Alessandria	006158	Sarezzano	566	561	1127
006	Alessandria	006159	Serralunga di Crea	259	249	508
006	Alessandria	006160	Serravalle Scrivia	2922	2969	5891
006	Alessandria	006161	Sezzadio	558	602	1160
006	Alessandria	006162	Silvano d'Orba	962	953	1915
006	Alessandria	006163	Solero	767	791	1558
006	Alessandria	006164	Solonghello	102	93	195
006	Alessandria	006165	Spigno Monferrato	462	453	915
006	Alessandria	006166	Spineto Scrivia	180	183	363
006	Alessandria	006167	Stazzano	1142	1187	2329
006	Alessandria	006168	Strevi	950	951	1901
006	Alessandria	006169	Tagliolo Monferrato	755	732	1487
006	Alessandria	006170	Tassarolo	309	290	599
006	Alessandria	006171	Terruggia	427	483	910
006	Alessandria	006172	Terzo	426	411	837
006	Alessandria	006173	Ticineto	621	678	1299
006	Alessandria	006174	Tortona	12747	13798	26545
006	Alessandria	006175	Treville	128	134	262
006	Alessandria	006176	Trisobbio	331	336	667
006	Alessandria	006177	Valenza	8582	9458	18040
006	Alessandria	006178	Valmacca	452	511	963
006	Alessandria	006179	Vignale Monferrato	446	498	944
006	Alessandria	006180	Vignole Borbera	986	1033	2019
006	Alessandria	006181	Viguzzolo	1524	1523	3047
006	Alessandria	006182	Villadeati	238	241	479
006	Alessandria	006183	Villalvernia	429	445	874
006	Alessandria	006184	Villamiroglio	153	145	298
006	Alessandria	006185	Villanova Monferrato	840	910	1750
006	Alessandria	006186	Villaromagnano	323	331	654
006	Alessandria	006187	Visone	581	546	1127
006	Alessandria	006188	Volpedo	566	589	1155
006	Alessandria	006189	Volpeglino	69	64	133
006	Alessandria	006190	Voltaggio	326	340	666
006	Alessandria	006191	Cassano Spinola	887	940	1827
006	Alessandria	006192	Alluvioni Piovera	790	817	1607
006	Alessandria	006193	Lu e Cuccaro Monferrato	643	682	1325
042	Ancona	042001	Agugliano	2309	2387	4696
042	Ancona	042002	Ancona	47747	50917	98664
042	Ancona	042003	Arcevia	2100	2149	4249
042	Ancona	042004	Barbara	638	629	1267
042	Ancona	042005	Belvedere Ostrense	1036	1065	2101
042	Ancona	042006	Camerano	3465	3643	7108
042	Ancona	042007	Camerata Picena	1255	1246	2501
042	Ancona	042008	Castelbellino	2363	2571	4934
042	Ancona	042010	Castelfidardo	9072	9386	18458
042	Ancona	042011	Castelleone di Suasa	798	789	1587
042	Ancona	042012	Castelplanio	1728	1778	3506
042	Ancona	042013	Cerreto d'Esi	1690	1718	3408
042	Ancona	042014	Chiaravalle	6720	7546	14266
042	Ancona	042015	Corinaldo	2328	2473	4801
042	Ancona	042016	Cupramontana	2170	2227	4397
042	Ancona	042017	Fabriano	14042	15065	29107
042	Ancona	042018	Falconara Marittima	12399	13238	25637
042	Ancona	042019	Filottrano	4431	4549	8980
042	Ancona	042020	Genga	821	841	1662
042	Ancona	042021	Jesi	18829	20354	39183
042	Ancona	042022	Loreto	6223	6653	12876
042	Ancona	042023	Maiolati Spontini	2921	3183	6104
042	Ancona	042024	Mergo	492	517	1009
042	Ancona	042025	Monsano	1612	1704	3316
042	Ancona	042026	Montecarotto	900	950	1850
042	Ancona	042027	Montemarciano	4914	4930	9844
042	Ancona	042029	Monte Roberto	1488	1523	3011
042	Ancona	042030	Monte San Vito	3296	3414	6710
042	Ancona	042031	Morro d'Alba	881	908	1789
042	Ancona	042032	Numana	1886	1863	3749
042	Ancona	042033	Offagna	1030	1009	2039
042	Ancona	042034	Osimo	17120	17621	34741
042	Ancona	042035	Ostra	3114	3273	6387
042	Ancona	042036	Ostra Vetere	1555	1572	3127
042	Ancona	042037	Poggio San Marcello	325	325	650
042	Ancona	042038	Polverigi	2271	2313	4584
042	Ancona	042040	Rosora	917	943	1860
042	Ancona	042041	San Marcello	992	1026	2018
042	Ancona	042042	San Paolo di Jesi	430	456	886
042	Ancona	042043	Santa Maria Nuova	1953	2023	3976
042	Ancona	042044	Sassoferrato	3335	3523	6858
042	Ancona	042045	Senigallia	21118	22970	44088
042	Ancona	042046	Serra de' Conti	1783	1810	3593
042	Ancona	042047	Serra San Quirico	1206	1353	2559
042	Ancona	042048	Sirolo	1965	2130	4095
042	Ancona	042049	Staffolo	1020	1050	2070
042	Ancona	042050	Trecastelli	3738	3706	7444

Hopefully, all the steps work for you, but let us know if you get stuck.

sal21 · Dec 7, 2022

John_w said:
Ok, I'll try to guide you through the steps to get the data for multiple provinces. Power Query is relatively new to me so some steps might not be optimum.

1. First, create the following table on a sheet and rename it Provinces.

Code Province
084 Agrigento
006 Alessandria
042 Ancona

The Code column is formatted as Text, and I had to type in the leading zeroes to make all the codes 3 digits long. For this guide, the Provinces table contains only 3 provinces but you can easily expand it to all the provinces.

2. Note - you could skip steps 2 and 3 and go directly to step 4 by creating a blank connection-only query named GetProvinceData, but here I will show you all the individual manual steps needed to get to the web data.

Next, create the basic query which sends a POST request for the province with code 084:

Data tab -> Get Data -> Other sources -> Blank Query. In Advanced Editor, replace everything with:

Power Query:

let url = "https://demo.istat.it/app/RPCCerca.php", body = "territorio=procom&province=084&hid-i=POS&hid-a=2022&hid-l=it&hid-cat=POS&hid-dati=dati-form-1&hid-tavola=tavola-form-1", Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content = Text.ToBinary(body) ] )) in Source

Click Done to close Advanced Editor.

3. Now we will drill down to the required data, which is in JSON format.

Click Record next to datatable.
Click List next to data.
Click To Table on the Transform tab. Click OK in the To Table dialogue.
Click the Expand icon at the top of Column1.
Select 5 columns: codistat, denominazione, mtot, ftot, totmf. Untick 'Use original column name as prefix'. Click OK.
Under Properties, change the name of the query from Query1 to GetProvinceData.
Click Advanced Editor to view the PQ code, which should be:

Power Query:

let url = "https://demo.istat.it/app/RPCCerca.php", body = "territorio=procom&province=084&hid-i=POS&hid-a=2022&hid-l=it&hid-cat=POS&hid-dati=dati-form-1&hid-tavola=tavola-form-1", Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content = Text.ToBinary(body) ] )), datatable = Source[datatable], data = datatable[data], #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"codistat", "denominazione", "mtot", "ftot", "totmf"}, {"codistat", "denominazione", "mtot", "ftot", "totmf"}) in #"Expanded Column1"

Click Done to close Advanced Editor.
Click Close & Load To...
Important: Click Only Create Connection. This creates a connection-only query named GetProvinceData.

4. Now change the GetProvinceData query to a custom function which accepts a parameter for the province code:

Edit the GetProvinceData query and in Advanced Editor replace everything with:

Power Query:

let GetProvinceData = (ProvinceCode as text) => let url = "https://demo.istat.it/app/RPCCerca.php", body = "territorio=procom&province="&ProvinceCode&"&hid-i=POS&hid-a=2022&hid-l=it&hid-cat=POS&hid-dati=dati-form-1&hid-tavola=tavola-form-1", Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content = Text.ToBinary(body) ] )), datatable = Source[datatable], data = datatable[data], #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"codistat", "denominazione", "mtot", "ftot", "totmf"}, {"codistat", "denominazione", "mtot", "ftot", "totmf"}) in #"Expanded Column1" in GetProvinceData

The changes to the previous PQ code are to 'embed' the let url .... in #Expanded Column1" structure inside the let GetProvinceData ..... in GetProvinceData structure, with the (ProvinceCode as text) parameter and concatenating the ProvinceCode parameter in the body string, replacing the 084 value.

5. Next, we will invoke the GetProvinceData custom function on each row in the Provinces table to return the data for all 3 provinces.

Select a cell in the Provinces table.
Data tab -> From Table/Range.
Important: In the PQ Editor, change the data type of the Code column to Text (Replace current). For some reason, PQ doesn't recognise that the Excel column is formatted as Text.
On the Add Column tab, click Invoke Custom Function.
In the Invoke Custom Function dialogue, choose GetProvinceData in the Function query dropdown. In the ProvinceCode dropdown, choose Code. Click OK.
If displayed, click Continue on the yellow privacy warning and tick 'Ignore Privacy Levels Checks for this file....' and click Save.
Click the Expand icon next to the GetProvinceData column. Select all 5 columns (codistat, denominazione, mtot, ftot, totmf) and untick 'Use original column name as prefix'.
On the Home tab, click Close & Load To... Choose Table option, and select the destination cell and worksheet for the new table.

The query returns 277 rows for the 3 provinces:

Code Province codistat denominazione mtot ftot totmf
084 Agrigento 084001 Agrigento 27188 28448 55636
084 Agrigento 084002 Alessandria della Rocca 1207 1293 2500
084 Agrigento 084003 Aragona 4220 4523 8743
084 Agrigento 084004 Bivona 1578 1648 3226
084 Agrigento 084005 Burgio 1214 1290 2504
084 Agrigento 084006 Calamonaci 578 595 1173
084 Agrigento 084007 Caltabellotta 1527 1694 3221
084 Agrigento 084008 Camastra 938 977 1915
084 Agrigento 084009 Cammarata 2920 2946 5866
084 Agrigento 084010 Campobello di Licata 4409 4684 9093
084 Agrigento 084011 Canicattì 16573 17771 34344
084 Agrigento 084012 Casteltermini 3521 3825 7346
084 Agrigento 084013 Castrofilippo 1211 1386 2597
084 Agrigento 084014 Cattolica Eraclea 1620 1687 3307
084 Agrigento 084015 Cianciana 1460 1639 3099
084 Agrigento 084016 Comitini 430 457 887
084 Agrigento 084017 Favara 15290 16311 31601
084 Agrigento 084018 Grotte 2452 2771 5223
084 Agrigento 084019 Joppolo Giancaxio 498 563 1061
084 Agrigento 084020 Lampedusa e Linosa 3307 3053 6360
084 Agrigento 084021 Licata 16840 17501 34341
084 Agrigento 084022 Lucca Sicula 845 884 1729
084 Agrigento 084023 Menfi 5674 6073 11747
084 Agrigento 084024 Montallegro 1161 1208 2369
084 Agrigento 084025 Montevago 1328 1385 2713
084 Agrigento 084026 Naro 3376 3601 6977
084 Agrigento 084027 Palma di Montechiaro 10134 11117 21251
084 Agrigento 084028 Porto Empedocle 7575 7911 15486
084 Agrigento 084029 Racalmuto 3650 3862 7512
084 Agrigento 084030 Raffadali 5840 6300 12140
084 Agrigento 084031 Ravanusa 5060 5393 10453
084 Agrigento 084032 Realmonte 2146 2225 4371
084 Agrigento 084033 Ribera 8596 9275 17871
084 Agrigento 084034 Sambuca di Sicilia 2667 2718 5385
084 Agrigento 084035 San Biagio Platani 1339 1539 2878
084 Agrigento 084036 San Giovanni Gemini 3728 3804 7532
084 Agrigento 084037 Santa Elisabetta 1032 1105 2137
084 Agrigento 084038 Santa Margherita di Belice 2908 3096 6004
084 Agrigento 084039 Sant'Angelo Muxaro 546 610 1156
084 Agrigento 084040 Santo Stefano Quisquina 1987 2151 4138
084 Agrigento 084041 Sciacca 18974 20141 39115
084 Agrigento 084042 Siculiana 2007 2071 4078
084 Agrigento 084043 Villafranca Sicula 647 695 1342
006 Alessandria 006001 Acqui Terme 8888 10114 19002
006 Alessandria 006002 Albera Ligure 170 145 315
006 Alessandria 006003 Alessandria 44063 46924 90987
006 Alessandria 006004 Alfiano Natta 364 365 729
006 Alessandria 006005 Alice Bel Colle 384 327 711
006 Alessandria 006007 Altavilla Monferrato 216 183 399
006 Alessandria 006008 Alzano Scrivia 183 164 347
006 Alessandria 006009 Arquata Scrivia 3041 3215 6256
006 Alessandria 006010 Avolasca 127 126 253
006 Alessandria 006011 Balzola 623 641 1264
006 Alessandria 006012 Basaluzzo 1012 993 2005
006 Alessandria 006013 Bassignana 764 782 1546
006 Alessandria 006014 Belforte Monferrato 258 240 498
006 Alessandria 006015 Bergamasco 343 366 709
006 Alessandria 006016 Berzano di Tortona 76 81 157
006 Alessandria 006017 Bistagno 869 887 1756
006 Alessandria 006018 Borghetto di Borbera 971 946 1917
006 Alessandria 006019 Borgoratto Alessandrino 253 283 536
006 Alessandria 006020 Borgo San Martino 673 680 1353
006 Alessandria 006021 Bosco Marengo 1154 1097 2251
006 Alessandria 006022 Bosio 546 509 1055
006 Alessandria 006023 Bozzole 162 143 305
006 Alessandria 006024 Brignano-Frascata 216 206 422
006 Alessandria 006025 Cabella Ligure 248 227 475
006 Alessandria 006026 Camagna Monferrato 227 241 468
006 Alessandria 006027 Camino 381 353 734
006 Alessandria 006028 Cantalupo Ligure 222 232 454
006 Alessandria 006029 Capriata d'Orba 888 881 1769
006 Alessandria 006030 Carbonara Scrivia 547 551 1098
006 Alessandria 006031 Carentino 165 156 321
006 Alessandria 006032 Carezzano 209 215 424
006 Alessandria 006033 Carpeneto 462 449 911
006 Alessandria 006034 Carrega Ligure 52 36 88
006 Alessandria 006035 Carrosio 261 233 494
006 Alessandria 006036 Cartosio 349 371 720
006 Alessandria 006037 Casal Cermelli 574 606 1180
006 Alessandria 006038 Casaleggio Boiro 185 185 370
006 Alessandria 006039 Casale Monferrato 15429 17091 32520
006 Alessandria 006040 Casalnoceto 489 478 967
006 Alessandria 006041 Casasco 62 59 121
006 Alessandria 006043 Cassine 1424 1395 2819
006 Alessandria 006044 Cassinelle 444 407 851
006 Alessandria 006045 Castellania 48 40 88
006 Alessandria 006046 Castellar Guidobono 202 196 398
006 Alessandria 006047 Castellazzo Bormida 2186 2239 4425
006 Alessandria 006048 Castelletto d'Erro 62 73 135
006 Alessandria 006049 Castelletto d'Orba 902 934 1836
006 Alessandria 006050 Castelletto Merli 233 217 450
006 Alessandria 006051 Castelletto Monferrato 719 710 1429
006 Alessandria 006052 Castelnuovo Bormida 296 316 612
006 Alessandria 006053 Castelnuovo Scrivia 2372 2491 4863
006 Alessandria 006054 Castelspina 196 196 392
006 Alessandria 006055 Cavatore 119 141 260
006 Alessandria 006056 Cella Monte 237 230 467
006 Alessandria 006057 Cereseto 206 189 395
006 Alessandria 006058 Cerreto Grue 149 153 302
006 Alessandria 006059 Cerrina Monferrato 637 667 1304
006 Alessandria 006060 Coniolo 230 215 445
006 Alessandria 006061 Conzano 475 477 952
006 Alessandria 006062 Costa Vescovato 165 151 316
006 Alessandria 006063 Cremolino 500 495 995
006 Alessandria 006065 Denice 83 87 170
006 Alessandria 006066 Dernice 88 92 180
006 Alessandria 006067 Fabbrica Curone 286 302 588
006 Alessandria 006068 Felizzano 1044 1071 2115
006 Alessandria 006069 Fraconalto 162 140 302
006 Alessandria 006070 Francavilla Bisio 255 251 506
006 Alessandria 006071 Frascaro 214 235 449
006 Alessandria 006072 Frassinello Monferrato 225 245 470
006 Alessandria 006073 Frassineto Po 663 693 1356
006 Alessandria 006074 Fresonara 325 298 623
006 Alessandria 006075 Frugarolo 901 984 1885
006 Alessandria 006076 Fubine Monferrato 770 808 1578
006 Alessandria 006077 Gabiano 522 495 1017
006 Alessandria 006078 Gamalero 382 434 816
006 Alessandria 006079 Garbagna 301 313 614
006 Alessandria 006081 Gavi 2188 2244 4432
006 Alessandria 006082 Giarole 311 359 670
006 Alessandria 006083 Gremiasco 148 143 291
006 Alessandria 006084 Grognardo 119 102 221
006 Alessandria 006085 Grondona 228 248 476
006 Alessandria 006086 Guazzora 146 148 294
006 Alessandria 006087 Isola Sant'Antonio 331 311 642
006 Alessandria 006088 Lerma 380 421 801
006 Alessandria 006090 Malvicino 35 44 79
006 Alessandria 006091 Masio 644 612 1256
006 Alessandria 006092 Melazzo 616 626 1242
006 Alessandria 006093 Merana 93 92 185
006 Alessandria 006094 Mirabello Monferrato 602 605 1207
006 Alessandria 006095 Molare 951 1047 1998
006 Alessandria 006096 Molino dei Torti 303 261 564
006 Alessandria 006097 Mombello Monferrato 441 480 921
006 Alessandria 006098 Momperone 104 91 195
006 Alessandria 006099 Moncestino 92 103 195
006 Alessandria 006100 Mongiardino Ligure 82 72 154
006 Alessandria 006101 Monleale 275 277 552
006 Alessandria 006102 Montacuto 132 119 251
006 Alessandria 006103 Montaldeo 108 124 232
006 Alessandria 006104 Montaldo Bormida 309 296 605
006 Alessandria 006105 Montecastello 143 147 290
006 Alessandria 006106 Montechiaro d'Acqui 259 241 500
006 Alessandria 006107 Montegioco 151 133 284
006 Alessandria 006108 Montemarzino 158 152 310
006 Alessandria 006109 Morano sul Po 637 669 1306
006 Alessandria 006110 Morbello 202 186 388
006 Alessandria 006111 Mornese 339 369 708
006 Alessandria 006112 Morsasco 292 313 605
006 Alessandria 006113 Murisengo 621 661 1282
006 Alessandria 006114 Novi Ligure 13180 14262 27442
006 Alessandria 006115 Occimiano 592 654 1246
006 Alessandria 006116 Odalengo Grande 207 201 408
006 Alessandria 006117 Odalengo Piccolo 124 115 239
006 Alessandria 006118 Olivola 54 60 114
006 Alessandria 006119 Orsara Bormida 198 202 400
006 Alessandria 006120 Ottiglio 296 296 592
006 Alessandria 006121 Ovada 5187 5661 10848
006 Alessandria 006122 Oviglio 588 604 1192
006 Alessandria 006123 Ozzano Monferrato 681 677 1358
006 Alessandria 006124 Paderna 101 97 198
006 Alessandria 006125 Pareto 279 237 516
006 Alessandria 006126 Parodi Ligure 315 295 610
006 Alessandria 006127 Pasturana 613 670 1283
006 Alessandria 006128 Pecetto di Valenza 576 576 1152
006 Alessandria 006129 Pietra Marazzi 417 447 864
006 Alessandria 006131 Pomaro Monferrato 144 162 306
006 Alessandria 006132 Pontecurone 1724 1688 3412
006 Alessandria 006133 Pontestura 634 668 1302
006 Alessandria 006134 Ponti 279 263 542
006 Alessandria 006135 Ponzano Monferrato 155 159 314
006 Alessandria 006136 Ponzone 527 473 1000
006 Alessandria 006137 Pozzol Groppo 152 143 295
006 Alessandria 006138 Pozzolo Formigaro 2269 2238 4507
006 Alessandria 006139 Prasco 241 237 478
006 Alessandria 006140 Predosa 922 964 1886
006 Alessandria 006141 Quargnento 649 689 1338
006 Alessandria 006142 Quattordio 733 766 1499
006 Alessandria 006143 Ricaldone 319 292 611
006 Alessandria 006144 Rivalta Bormida 677 700 1377
006 Alessandria 006145 Rivarone 229 162 391
006 Alessandria 006146 Roccaforte Ligure 74 49 123
006 Alessandria 006147 Rocca Grimalda 740 685 1425
006 Alessandria 006148 Rocchetta Ligure 119 99 218
006 Alessandria 006149 Rosignano Monferrato 698 757 1455
006 Alessandria 006150 Sala Monferrato 163 177 340
006 Alessandria 006151 Sale 1901 2002 3903
006 Alessandria 006152 San Cristoforo 258 281 539
006 Alessandria 006153 San Giorgio Monferrato 583 618 1201
006 Alessandria 006154 San Salvatore Monferrato 2003 2040 4043
006 Alessandria 006155 San Sebastiano Curone 247 280 527
006 Alessandria 006156 Sant'Agata Fossili 175 192 367
006 Alessandria 006157 Sardigliano 186 200 386
006 Alessandria 006158 Sarezzano 566 561 1127
006 Alessandria 006159 Serralunga di Crea 259 249 508
006 Alessandria 006160 Serravalle Scrivia 2922 2969 5891
006 Alessandria 006161 Sezzadio 558 602 1160
006 Alessandria 006162 Silvano d'Orba 962 953 1915
006 Alessandria 006163 Solero 767 791 1558
006 Alessandria 006164 Solonghello 102 93 195
006 Alessandria 006165 Spigno Monferrato 462 453 915
006 Alessandria 006166 Spineto Scrivia 180 183 363
006 Alessandria 006167 Stazzano 1142 1187 2329
006 Alessandria 006168 Strevi 950 951 1901
006 Alessandria 006169 Tagliolo Monferrato 755 732 1487
006 Alessandria 006170 Tassarolo 309 290 599
006 Alessandria 006171 Terruggia 427 483 910
006 Alessandria 006172 Terzo 426 411 837
006 Alessandria 006173 Ticineto 621 678 1299
006 Alessandria 006174 Tortona 12747 13798 26545
006 Alessandria 006175 Treville 128 134 262
006 Alessandria 006176 Trisobbio 331 336 667
006 Alessandria 006177 Valenza 8582 9458 18040
006 Alessandria 006178 Valmacca 452 511 963
006 Alessandria 006179 Vignale Monferrato 446 498 944
006 Alessandria 006180 Vignole Borbera 986 1033 2019
006 Alessandria 006181 Viguzzolo 1524 1523 3047
006 Alessandria 006182 Villadeati 238 241 479
006 Alessandria 006183 Villalvernia 429 445 874
006 Alessandria 006184 Villamiroglio 153 145 298
006 Alessandria 006185 Villanova Monferrato 840 910 1750
006 Alessandria 006186 Villaromagnano 323 331 654
006 Alessandria 006187 Visone 581 546 1127
006 Alessandria 006188 Volpedo 566 589 1155
006 Alessandria 006189 Volpeglino 69 64 133
006 Alessandria 006190 Voltaggio 326 340 666
006 Alessandria 006191 Cassano Spinola 887 940 1827
006 Alessandria 006192 Alluvioni Piovera 790 817 1607
006 Alessandria 006193 Lu e Cuccaro Monferrato 643 682 1325
042 Ancona 042001 Agugliano 2309 2387 4696
042 Ancona 042002 Ancona 47747 50917 98664
042 Ancona 042003 Arcevia 2100 2149 4249
042 Ancona 042004 Barbara 638 629 1267
042 Ancona 042005 Belvedere Ostrense 1036 1065 2101
042 Ancona 042006 Camerano 3465 3643 7108
042 Ancona 042007 Camerata Picena 1255 1246 2501
042 Ancona 042008 Castelbellino 2363 2571 4934
042 Ancona 042010 Castelfidardo 9072 9386 18458
042 Ancona 042011 Castelleone di Suasa 798 789 1587
042 Ancona 042012 Castelplanio 1728 1778 3506
042 Ancona 042013 Cerreto d'Esi 1690 1718 3408
042 Ancona 042014 Chiaravalle 6720 7546 14266
042 Ancona 042015 Corinaldo 2328 2473 4801
042 Ancona 042016 Cupramontana 2170 2227 4397
042 Ancona 042017 Fabriano 14042 15065 29107
042 Ancona 042018 Falconara Marittima 12399 13238 25637
042 Ancona 042019 Filottrano 4431 4549 8980
042 Ancona 042020 Genga 821 841 1662
042 Ancona 042021 Jesi 18829 20354 39183
042 Ancona 042022 Loreto 6223 6653 12876
042 Ancona 042023 Maiolati Spontini 2921 3183 6104
042 Ancona 042024 Mergo 492 517 1009
042 Ancona 042025 Monsano 1612 1704 3316
042 Ancona 042026 Montecarotto 900 950 1850
042 Ancona 042027 Montemarciano 4914 4930 9844
042 Ancona 042029 Monte Roberto 1488 1523 3011
042 Ancona 042030 Monte San Vito 3296 3414 6710
042 Ancona 042031 Morro d'Alba 881 908 1789
042 Ancona 042032 Numana 1886 1863 3749
042 Ancona 042033 Offagna 1030 1009 2039
042 Ancona 042034 Osimo 17120 17621 34741
042 Ancona 042035 Ostra 3114 3273 6387
042 Ancona 042036 Ostra Vetere 1555 1572 3127
042 Ancona 042037 Poggio San Marcello 325 325 650
042 Ancona 042038 Polverigi 2271 2313 4584
042 Ancona 042040 Rosora 917 943 1860
042 Ancona 042041 San Marcello 992 1026 2018
042 Ancona 042042 San Paolo di Jesi 430 456 886
042 Ancona 042043 Santa Maria Nuova 1953 2023 3976
042 Ancona 042044 Sassoferrato 3335 3523 6858
042 Ancona 042045 Senigallia 21118 22970 44088
042 Ancona 042046 Serra de' Conti 1783 1810 3593
042 Ancona 042047 Serra San Quirico 1206 1353 2559
042 Ancona 042048 Sirolo 1965 2130 4095
042 Ancona 042049 Staffolo 1020 1050 2070
042 Ancona 042050 Trecastelli 3738 3706 7444

Hopefully, all the steps work for you, but let us know if you get stuck.

SUPER GREAT!

very stange to select item in web dropdown and click on "cerca"

sal21

Active Member

Popolazione residente

Excel Facts

Automatrix

Active Member

sal21

Active Member

Automatrix

Active Member

sal21

Active Member

Automatrix

Active Member

John_w

MrExcel MVP

sal21

Active Member

John_w

MrExcel MVP

sal21

Active Member

Similar threads

Forum statistics

Share this page

very stange to select item in web dropdown and click on "cerca"

Active Member

Excel Facts

Active Member

Active Member

Active Member

Active Member

Active Member

MrExcel MVP

Active Member

MrExcel MVP

Active Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock