Is there a way you can have data coming from external sources like a microsoft query into the worksheet and the data it brings in will automatically update? If so how often? If not is there a way to allow that to happen?
also posted this here:
Pulling data from external sources in Excel
also posted this here:
Pulling data from external sources in Excel