-Dennis Wallentin
XL-Dennis is an independent consultant company, situated in Östersund Sweden. The company offers advanced MS Excel consultancy and solution development. XL-Dennis was founded by Dennis Wallentin who has been developing MS Excel solutions since the 1980’s. Dennis has a Masters in Business Management & Accounting. XL-Dennis utilizes MS Excel and other tools to develop professional business solutions. XL-Dennis delivers solutions for all sizes of companies including the public sector in both Sweden and internationally.
Author website: www.excelkb.com
Creating basic data reports with ListObjects and QueryTables | Expert Zone
2008-01-09
In this article we will take a closer look on how we can create a basic data report with VBA for Excel 2003 and 2007. With a basic report I refer to solutions where data is, for instance, retrieved from a central database, which is then placed in a worksheet.