Hello, guys. I am a newcomer to VBA. I would like to have some help from you guys. Please help!
I need a set of VBA code that generate worksheet according to a template and fill in a cell in each new worksheet according the cell values in a list.
In an excel workbook, I have a well developed-template to download stock data using Reuters add-on. In cell A1, it is the ticker of the stock.
I hope to have the following function. I hope to select some cells which contained the tickers. Then I run the macro. It generates the spreadsheets and rename them to the tickers. It fills in cell A1 with the tickers. That's it. The sequence of the worksheets should follow the sequence in the master list.
Thanks a lot!