1 New Message
Digest #2643
Message
Tue Jun 4, 2013 7:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It only does it the one way, sorry.
But rather than write all of your own code for a transposed version, why
not just run it as-is and then transpose it, putting the output in another
worksheet?
On Tue, Jun 4, 2013 at 7:42 PM, MLawson <mlawson3@yahoo.com > wrote:
> I'd like to populate a typical financial statement spreadsheet, i.e.,
> categories running from top to bottom along the left side of a table while
> the reporting periods run left to right across the top, using a function
> similar to the smfdowloadtableupdate (?name?). Before I start declaring
> arrays and piggy-backing off the code you have written, do you have an
> off-the-shelf version laying around? I am trying to avoid creating a
> spreadsheet with a few hundred formulas in it for 10 years worth of
> financial data.
>
But rather than write all of your own code for a transposed version, why
not just run it as-is and then transpose it, putting the output in another
worksheet?
On Tue, Jun 4, 2013 at 7:42 PM, MLawson <mlawson3@yahoo.
> I'd like to populate a typical financial statement spreadsheet, i.e.,
> categories running from top to bottom along the left side of a table while
> the reporting periods run left to right across the top, using a function
> similar to the smfdowloadtableupda
> arrays and piggy-backing off the code you have written, do you have an
> off-the-shelf version laying around? I am trying to avoid creating a
> spreadsheet with a few hundred formulas in it for 10 years worth of
> financial data.
>
Tidak ada komentar:
Posting Komentar