Hello,
I have a workbook with several sheets retrieving data from an external source using an Excel add-in.
The data is compiled into formatted "tables"/reports (the retriever is built with formulas cells-by-cells only retrieving the data to that specific cell, not a table as a whole) , having headers, dates etc.
I would like to automatically/macro update (copy) the values from multiple cell ranges in the workbook and paste them as values in identical structured/formatted reports, but with values only.
What is the best way to set this up? Ideally it would be setup that table ranges could be changed without to much hassle, e.g. if I need to update one of the reports.
My experience with VBA (which I assume to be the solution here) is very limited.
Thanks,
I have a workbook with several sheets retrieving data from an external source using an Excel add-in.
The data is compiled into formatted "tables"/reports (the retriever is built with formulas cells-by-cells only retrieving the data to that specific cell, not a table as a whole) , having headers, dates etc.
I would like to automatically/macro update (copy) the values from multiple cell ranges in the workbook and paste them as values in identical structured/formatted reports, but with values only.
What is the best way to set this up? Ideally it would be setup that table ranges could be changed without to much hassle, e.g. if I need to update one of the reports.
My experience with VBA (which I assume to be the solution here) is very limited.
Thanks,