Hi all, I have a workbook where are 4 sheets namely (IMP, URIAGE, FILORGA, ISDIN respectively). In sheet IMP there is a dropdown list containing the names URIAGE, FILORGA, ISDIN and in each of those sheets there are tables with fixed header. What I want to do is when I select a item from the list in sheet IMP (cell A1) the table from the appropriate sheet should get pasted starting from the position B2 in sheet IMP.
The end product should look like this
pic1.png
pic2.png
pic3.png
I've also tried name the tables for sheets URIAGE, FILORGA, ISDIN as TabU, TabF, TabI respectively and tried pasting the below formula on cell B2 but it shows "you have entered two many argument in this function" error:
Help !!
Bookmarks