Macro that runs data-validated cell individually through the list it is based on - Part2

[dks345]

I have a workbook where cell B3 (tab1) is a data-validated cell based on a list from tab2. I would like to write a macro that runs this cell through each item in the list so that it will populate another table that uses self-referencing cells (tab 2). I can do this manually by clicking through the list in cell B3. I would like to cell B3 to automatically run through each item on the list.

I received a great solution to this when all the tables were on the same worksheet:

Please Login or Register  to view this content.

However, I have now placed the selector cell and table list on separate worksheets so the code above no longer works. Now that the cells are on different worksheets, how can I modify the code so that it will work accordingly? Please see attached workbook as it illustrates better than I can explain here.

Thank you for your help!

[rylo]

Hi

Can you please edit your post and put code tags around the code.

Revamp

Please Login or Register  to view this content.

rylo