How to automatically create and populate worksheets?
Another option, especially if you expect your underlying worksheet to
change over time, would be to set up external data queries for each of
the values. Then, all you need to do is refresh the query (or have it
do it itself automatically) whenever you need it to be updated.
|