Hi,
The other day I asked a question about how to automatically have excel create worksheets for me, based on a list,
http://www.experts exchange.com/Software/Offi
ce_Product
ivity/Offi
ce_Suites/
MS_Office/
Excel/Q_23
408806.htm
l#a2158488
5
The code I was given works well, however I am having a problem. I have attached a copy of the excel file I am working on as a reference. Basically, right now if I type in a stock symbol into cell A1 of the "ref" sheet, a new worksheet is created from the my "template" worksheet. The code given to me automatically puts the newly created worksheet's name into cell A1 of the new sheet, which makes sure all the data for that stock gets entered in. The problem is when I try to enter in 2 stocks symbols at the same time into the "ref" sheet, I get an error msg. Similarly, if there is already a list of stock symbols there and I try to delete two or more of the symbols at the same time, I get an error msg. One final problem is that I would like it so that only the stocks symbols entered into column A are recognized and created as new worksheets, and Im not sure how to do that. Any help is greatly appreciated,
Greg
Start Free Trial
