Create multiple copies of a sheet by updating data from a web source

aman17

New Member
Joined
Aug 4, 2021
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
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!
 

Attachments

  • Screenshot 2021-08-04 104351.png
    Screenshot 2021-08-04 104351.png
    65.1 KB · Views: 14

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,223,236
Messages
6,170,912
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top