Looping VBA Query

[zhb12810]

Hello,

Basically I have the following VBA queries that bring some data from some .dbf files into Excel

What I’m looking to do (If possible) is align the 3rd query (CBARTOT) with the second query (CBARSUM), this itself is very easy and not a problem, then based on the value in the first column of CBARSUM (A23) sum all the columns in CBARTOT and then loop down using the value in A24 and so on until there are no more values in the A column. Now CBARSUM could contain any number between 1 & 10 records as this query updates to a variety of different CBARSUM dbf files.

I’ve attached a test workbook if that helps

Please Login or Register  to view this content.

Many Thanks