A Semi automated way to note the IP addresses of things viewing us

[DocAElstein]

A walk through another Summary,
(This time Wednesday 16 July to Wednesday 23 July,
( A week from deletion of top post showthread.php?t=2993/Alan and Clare Testing )

About a week ago I brought all the day measurements together, for the period of about 19 days
28 June – 15 July 2025
https://www.excelfox.com/forum/showt...ll=1#post25073
https://www.excelfox.com/forum/showt...ll=1#post25074
https://www.excelfox.com/forum/showt...ll=1#post25075

Lets do the same for about the week after that , Wednesday/Thursday 16/17 July - Thursday 24 July , which will also be the week after I deleted a Thread which was usually top of the views list, ( showthread.php?t=2993/Alan and Clare Testing )

We need the files from that period: ( or rather we don't*** )

 

https://app.box.com/s/dp7em0dwgjvfmqh6dupx3pfy24d2zgbt   IPAddressesWatchingExcelFox_Refresh_Thursday 24 July, 2025 15min 4460 217.xls

https://app.box.com/s/ougkv441qjj5ofybcmf12egcu9csff75  IPAddressesWatchingExcelFox_Refresh_Wednesday 23 July 2025 15min 4680 232.xls

https://app.box.com/s/0xwrd8hji3a1vr0ky1mdhm8bjzw9sgp8      ‘IPAddressesWatchingExcelFox_Refresh_Tuesday Evening 22 July 2025 15min 4640 232.xls’

https://app.box.com/s/1ueglq4tp6k0zjsb0zec1mh8c843bt2z    IPAddressesWatchingExcelFox_Refresh_Tuesday 22 July 2025 15min 4700 236.xls 

https://app.box.com/s/bo1htufkcw33kvin0vm02yloc1od11sw    IPAddressesWatchingExcelFox_Refresh_Monday Evening 21 July 2025 15min 4600 223.xls

https://app.box.com/s/ihal0jb4tmisvtrq613tezyca52jo10f  IPAddressesWatchingExcelFox_Refresh_Monday 21 July 2025 18min 4693 240.xls

https://app.box.com/s/bu4zvdl5goltidjimsmsbur239j18mvf    IPAddressesWatchingExcelFox_Refresh_Sunday 20 July 2025 15min 223.xls

https://app.box.com/s/kkd0ff0vwken8474qdlqp1cm2q8ip08l  IPAddressesWatchingExcelFox_Sunday 20 July, 2025 225.xls

https://app.box.com/s/4d8hmesm26ai4nmt48v9fu822zw9vb1y   PAddressesWatchingExcelFox_Saturday 19 July, 2025 4745 238.xls

https://app.box.com/s/v9tkfhv30ksge4f7vupspfdessybhknl    IPAddressesWatchingExcelFox_Friday 18 July 2025 4690 235 43min.xls
https://app.box.com/s/5bw48x0ljjeqhz9fmqti9xj1xp554xgz      https://app.box.com/s/jx4r0e93amq58ug1rrvvq42g6b8ud00p    IPAddressesWatchingExcelFox_Friday 18 July 2025 Refresh 235 45min.xls

 https://app.box.com/s/99ycb1igkz3zqadhzudz9kjbf3uxpdqo       IPAddressesWatchingExcelFox_Thurs 17 July 2025_4658 233 36min.xls 

https://app.box.com/s/hgf7tqhdmbi8ss3hj408vbe1lxzlwvjf  IPAddressesWatchingExcelFox_Wed 16 July 2025_Gone Clare 4775 239.xls

---

OK. So we need the latest RequestsIPsSummary.xls file open and then two possibilities:
_(i) sequentially the files above open, and With each file from above open, we use the codings used already each time to get in the clipboard something to paste manually in the extra two worksheets in the file RequestsIPsSummary.xls
_(ii) use the coding in the next post, which, working on the top left of the ranges in RequestsIPsSummary.xls , then will paste them in the worksheets AllRequests or AllIPs

***I will use _(ii).
I had used _(i) before as I had not yet got all files into RequestsIPsSummary.xls

( For either option, range C:D is cleared initially as it will have them all. I do that by shifting the other columns for the Sat 28 June to 15 July Wednesday. (There were a few columns due to the quirk that the codings to reduce to unique values needed to be done a few times. So I may reconsider that coding later.