View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Randy Harmelink Randy  Harmelink is offline
external usenet poster
 
Posts: 122
Default 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.