I give up...S & P 500 formatting issue....

**sosopitt** · 06-26-2010, 03:15 PM

I give up.

If anyone can solve this for me than you are officially my hero.

I've attached a small piece of the spreadsheet I need formatted. The sheet contains all of the stock data for the SP 500 over the last year. I only left the stocks with tickers starting with "A" to make the spreadsheet (column B) a little more manageable but needless to say, it's BIG.

Here's what I need to do: I need a macro that will put the each stock in it's own worksheet, with the title of that worksheet being the stock ticker. That's 500 worksheets total (although in the attached file there's probably only a couple dozen.) Each time I pull the data the number of days each stock reports is different so that may add a kink to things.

For instance, I tried a macro that would cut the first 260 or so columns and then paste them into a new worksheet, delete the remaining empty rows on worksheet one, then rinse and repeat. Problem is different stocks have different numbers of days that get pulled (don't ask why).

So if ANYONE can solve this I would be greatly appreciative. See the attached file for reference.

D

**Leith Ross** · 06-26-2010, 05:38 PM

Hello sospitt,

I have added a button to the main worksheet to run the macro. There seems to be a problem with uploading files right now. I will attempt to upload the workbook later. Here is the macro code if you want to add this to your workbook yourself.

Please Login or Register  to view this content.

**sosopitt** · 06-26-2010, 06:27 PM

You sir, are amazing. No clue how you did it, but you did it in style and I applaud you.

I'm currently working for a major financial institution in San Francisco (I see you're from here as well). I'll be sure to keep you name at the top of the code. If, by some miracle for both of us, I strike technical analysis gold, I'll be sure to let some of the love flow your way.

God bless. Enjoy the beautiful weather today.

D