I have 3 tables,
Tab3 containing data and an empty table
The user can select in a drop-down list,
On the selection from user the empty table
Tab will be populated with the corresponding table.
For example, when the user selects
Tab is populated with the data from
Tab2; all the tables have the same size.
I could manage to use
INDIRECT to add value for one cell but not to the complete table.
Have you any ideas, any easy formula for Excel 2007. I am not using VBA.