Hi Guys!
Hope you are all great. I would like to know if there is a way to create an excel workbook containg a table and chart using the information from an existing workbook and sheet.
The thing is that I have a table with information and I would like to create a code that copies that information and creates in a new woorkbook the same table with a chart.
I have found a code which creates the woorkbook and the table only if I writte in the code how the table should be with the information, however I would like to know if it possible what I am asking for.
Thanks for all your help in advanced.
Hope you are all great. I would like to know if there is a way to create an excel workbook containg a table and chart using the information from an existing workbook and sheet.
The thing is that I have a table with information and I would like to create a code that copies that information and creates in a new woorkbook the same table with a chart.
I have found a code which creates the woorkbook and the table only if I writte in the code how the table should be with the information, however I would like to know if it possible what I am asking for.
Thanks for all your help in advanced.