Thank you so much Hui.
I never knew that you coulduse Data Connection to link back to the same page. Let me try this
I am planning to save the file as an Excel template so that when the user open the file, the data gets refreshed.
However, thanks once again for taking time to post a...
Request the valuable assistance of all the Excel Gurus with this challenge
I have 2 dynamic excel lists in a single sheet
List 1 - Item A, Item B, Item C ...
List 2 - Item P, Q, B, A1..
Some items are common in both the list.
My challenge
On another shhet on the same workbook, I need...