Hello
I have a file where in there are multiple sheets of the source data. Based on the inputs by the user, the data needs to be called in the respective cells.
For example, in Sheet 1, the user inputs values in D3 to D7. the matching data should get picked up from all the respective sheets and get populated in cells b12 to b81.
Any thoughts or codes that i can use to achieve this task?
Thanks
Sahil
Bookmarks