View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MadHenry MadHenry is offline
external usenet poster
 
Posts: 5
Default Replacing table with another table

How can I replace one table with another table from another sheet?

The table I want to replace is for example TABLE1 and the replacement is
TABLE2 in sheet2
I want to do it automatically with scripting.. when somebody chooses a name
from the list.. then next to the list there's a table.. and I want it to
change so there's new data according to the name of the chosen list item