Hi! I have an excel notebook (master notebook) with a main sheet and some other sheets containing some data used by the main sheet. The main sheet has a cell whose value is used by multiple queries in the supporting sheets to fetch data from a web source using an excel add-in. I have another notebook that contains a list of values in a single column. The task I wish to accomplish goes like this:
1. Fetch the first value from the range in the other notebook (helper notebook)
2. Copy that value in a particular cell of the main sheet of the master notebook
3. Refresh the master notebook so that all the queries get re-run again and all the data is updated.
4. After refreshing, save only the main sheet in the master notebook as a separate CSV file in the same folder where the master notebook is located.
5. Repeat this process for all the values in the range in the other notebook so that we finally have one CSV file for every value in the other notebook (helper).
I am new to excel and any help will be really appreciated. Sorry if this question has been already answered. If yes, please share the link to that thread. Thanks!
1. Fetch the first value from the range in the other notebook (helper notebook)
2. Copy that value in a particular cell of the main sheet of the master notebook
3. Refresh the master notebook so that all the queries get re-run again and all the data is updated.
4. After refreshing, save only the main sheet in the master notebook as a separate CSV file in the same folder where the master notebook is located.
5. Repeat this process for all the values in the range in the other notebook so that we finally have one CSV file for every value in the other notebook (helper).
I am new to excel and any help will be really appreciated. Sorry if this question has been already answered. If yes, please share the link to that thread. Thanks!