Web Query - download multiple url & name sheets

[JohnDouglas]

Hi guys

I have a sheet with:

column A = Name
column B = URL
column C = download?

Please could you tell me how to get a webquery to do the following:

If column C had "y" in it then the URL in column B will be downloaded and the sheet named after the name in column A.

Macro will go through every url in column B checking if there's a "y" in the corresponding row to see if the URL needs to be downloaded.

Many thanks

John