Alek has attended:
Excel VBA Advanced course
VBA code to convert spreadsheet content to dynamic arrays
In the course it was suggested we should start using dynamic tables in all workbooks. Is there a way to automate process of converting spreadsheet content to dynamic to allow autoupdating of tables, charts etc.
RE: VBA code to convert spreadsheet content to dynamic arrays
Hi Alek,
Thank you for the forum question.
Dynamic tables are amazing to save time, but to automate creating them is not easy. We need to be able to identify the ranges we want to convert and each table need to have unique name.
I have created an example. Please find attached file.
You will find the attachment below my signature. If you cannot see it please wait 5 minutes and refresh your browser.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
