[ExcelVBA] Reconfiguring from excel spreadsheet

 

I may be in the wrong group. Maybe this can be done with Excel commands only.

I download sometimes a decade's worth of quarterly financial info in spreadsheet form. The amounts are fine but the quarterly labels (ie 2008/12) are text. So the first challenge is to change the text into something excel will recognize as dates. I think I can handle that. However, I need to take the info that is all on one row and sort it by year and by quarter so all March quarters in a column, all June quarters in another and so on. That will let me determine seasonality in the numbers: for instance, if 80% of 1st quarter growth in the last decade has been negative. That would be the lull after a busy holiday season.

Might this be an easy task for a relative newcomer?

Thanks,
David

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 9

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___