118 reputation
6
bio website
location Australia
age
visits member for 2 years, 7 months
seen Oct 14 at 0:23

Mar
19
comment Word 2010 caption has no number
I Have the same problem as the above. Showing field code does not work as caption is not being inserted as a field that can be updated...
Sep
24
comment Excel File Names not Displayed
I dont know if this has something to do with it but I normally can't open two windows next to each other they both use the same instance, but at the moment I am able to snap multiple excel windows side by side. Does this have something to do with why I can't see the doc title?
Dec
11
comment Forecasting growth in pivot tables
Yeah I realised that the pivot table wasn't actually appropriate for what I was trying to achieve. Excel's grouping function and a summary page was enough :P Also I don't know how to delete comments. Id like to upload the excel sheet for further explanation, but again, im not sure how to upload files, and the data is all sensitive. If there's enough interest in the question I may clean & upload the file...
Dec
3
comment Forecasting growth in pivot tables
The reason I wanted to go to a pivot system is that the actual data is about 20 columns by 200 rows, needs to be disected in multiple dimensions (by year, by sub department, YoY growth, base growth, etc), and using a pivot system would save me having to manually create all the reports. On a side not, if you put 2nd comment as an answer rather than a comment I can close the thread as that essentially solved my original problem. Again, many thanks for the help in a poorly explained problem
Dec
2
comment Forecasting growth in pivot tables
From what I understand, if i project the growth rate using a formula with each year in a different column, if i then wanted to report on these caculation using pivot tables/charts, i would then need to alter the data so that it was in a normalised list (e.g. column titles would be 'year', 'units', 'cost')
Dec
2
comment Forecasting growth in pivot tables
Thanks for the heads up. So Do you then find that its a problem normalising the data after you have created the worksheet in a matrix formation?
Nov
29
comment Forecasting growth in pivot tables
Apologies. should have specified it is the growth (i.e. year on year units increase by 133 on average)
Sep
12
comment Select multiple objects on top of simlanes
This solution does not really work in the context off rapidly adding new shapes, have multiple shapes in multiple groups, and having up to 100 shapes in a group. many thanks for the help, but i think this serves as more of an addition to the work around, but not a solution
Jun
8
comment Excel autosave versioning
That macro is close. it saves the file, but i need it to return the file back to its original filename. Will modify and see if i can get it to work. The only thing im not sure how to do is to get the version number if it is not appended to the current workbook? Thankyou very much for pointing in the right direction.
Jun
8
comment Excel autosave versioning
Thanks for the quick reply. That code should do exactly what i want. My preferred option is dropbox, but our silly group policy forbids it ('security issues'). Cheers!
May
28
comment Refreshing Crystal Reports through Excel Macro
Will do. When i originally found the answer i did not have enough rep to answer my own question. Will provide a more detailed answer below
May
17
comment Refreshing Crystal Reports through Excel Macro
To resolve the issue, i created an odbc connection to the database and used the data sources tab in excel to directly import the data into excel
May
3
comment Make numbered list with update feature?
@slhck: thanks but Excelll has a better answer anyways