Small changes to Excel VBA script

The Excel VBA works in three steps: 1/ Connect to webserver and retrieve data in sets of 50 rows 2/ Extract data with JSON parser 3/ Store data in Excel table Currently: the Excel VBA is fully operational and stable. The Excel VBA collects data from a webserver through a REST API. The Excel uses standard libraries to connect and retrieve the rows of data. The Excel uses a JSON parser to extract the selected items from the rows of data. Requested changes: -------------------------------- 1/ The While-Do loop is inverted and should be a Do-While. In order to parse through the multiple sets of 50 rows a While-Do loop has been added. In the event of more than 50 rows, the script must start another query to retrieve the next set of rows. However, I think that the code could be cleaned up by inverting the loop into a Do-While 2/ The resulting Tables must be cleaned up 2.1/ Remove table filter before update The data has been stored in a Excel table. If there is a filter active in the table when a refresh is started then the table is not updated correctly. Sometimes this results in blank rows in the table after update. Or other times the new rows are not appended to the table. So, I would like to have the filters automatically removed before the start of the refresh 2.2/ Add Total row I would like to add a total row for the colums with numerical values. In attachment the Excel with VBA. Thanks for your consideration Since you can't connect to the webserver you won't be able to test your VBA changes yourself. I will have to execute on my side. As a consequence some back and forth is to be expected. But it should be minimal.