| Is anyone good in creating Excel Macros or VBA? - Click HERE for Original Thread |
| 3gEdmonton |
| Need some input/help in creating a macros in Excel. Pm me and i'll explain the details just a bit complicated |
|
|
| TrevorK |
quote:
Originally posted by 3gEdmonton
Need some input/help in creating a macros in Excel. Pm me and i'll explain the details just a bit complicated
Post the details here - I'm sure there are quite a few of us who have done VBA macros before. |
|
|
| 3gEdmonton |
Thanks Trev,
OK here is the issue I'm doing some daily reports taking information from an essbase source and creating a stats document. In Essbase reports on individual servers pull up this way:
Data load #####################
Calculation ################## Custom calc
Outline update #######################
There is no way in changing the order of the information. Proceure now is to have it this way
Outline update #######################
Data load #####################
Calculation ################## Custom calc
So Outline > Data Load > Calculation
There are 40 to 50 different server stats that need to be taken from essbase. Currently I do a simple copy paste to a word doc. Then go in edit but it takes way too much time. I'm thinking of putting it in excel but I'm not too strong in VBA and haven't touched it in awhile. Is there such a possibility in creating a macro that will just change/flip the order? Let me know guys any help/input is much appreciated |
|
|
| TrevorK |
So the data appears as:
Data Load
Calculation
Outline update
There are 40-50 sections of these three lines.
And you want them to appear as:
Outline update
Data Load
Calculation
And that's it?
Then yeah - you should be able to build it without a problem.
A simple way, with very poor logic (But very simple) is to just build another sheet with the macro and copy the cells into the right lines.
Because Outline Update is always going to be on line 1, 4, 7, 10, 13 you can use poor logic (Which makes it simple to program) and just loop through the original and copy it to the destination.
Send me a copy of the spreadsheet: trevork@compuvision.biz and I'll see if I have time in between DVDs at my second job to take a look at it for you. |
|
|
| 3gEdmonton |
| OK I'll send you an email of the reports in word doc. the before and after. Specified in the email. Thanks for the help man much appreciated |
|
|
| TrevorK |
| No problem - I just spend my evenings playing online Monopoly/Risk at my second job, so this might be more interesting. |
|
|
|
|
|
