I would like to automate the building of webqueries.
I have this macro but it works for only for 1 symbol, in 1 cell for 1 month.
I would like to copy the Symbol from cell 4 in the active column and the
month from cells 7,8,9 and 10 respectively. After S32 the destination cell
should be the active cell. i.e. 32, 382, 732, 1082.
The Macro has to run untill no Symbol is found.
Please see attached sheet.
Please Login or Register to view this content.