Hello experts,
As quite a beginner in VBA I would like your help to create a function that takes 2 variables. The one is a cell which contains the name of the sheet I would like the data from and the second the specific cell in the aforementioned sheet to take the specific value.
I know that it may be quite easy, but I have not found it somewhere.
Also, is it possible to take the data from other workbooks? The problem is that I have already 50 sheets and I will need to create many more.
Thank you for the help.
As quite a beginner in VBA I would like your help to create a function that takes 2 variables. The one is a cell which contains the name of the sheet I would like the data from and the second the specific cell in the aforementioned sheet to take the specific value.
I know that it may be quite easy, but I have not found it somewhere.
Also, is it possible to take the data from other workbooks? The problem is that I have already 50 sheets and I will need to create many more.
Thank you for the help.