RE: [ExcelVBA] Reconfiguring from excel spreadsheet

 

I am sure we can help you, but first we need to see a sample of the data you
are dealing with. Could you copy some of the data and paste it into an
email so that we can identify the characters to define the column and line
breaks?

Best Regards
David Grugeon
Excel VBA Group Moderator

-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of dmrosy
Sent: Wednesday, 20 July 2011 4:29 AM
To: ExcelVBA@yahoogroups.com
Subject: [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

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

----------------------------------
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

----------------------------------Yahoo! Groups Links

__._,_.___

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

Messages in this topic (2)

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

.

__,_._,___