118 reputation
5
bio website
location Australia
age
visits member for 2 years, 4 months
seen Mar 19 at 22:41

Mar
19
awarded  Supporter
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
answered Office 2007 removal will the email data be saved or disacarded
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?
Sep
24
asked Excel File Names not Displayed
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
11
accepted Forecasting growth in pivot tables
Dec
3
awarded  Commentator
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)
Nov
29
asked Forecasting growth in pivot tables
Nov
20
accepted Select multiple objects on top of simlanes
Sep
13
answered Select multiple objects on top of simlanes
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
Sep
12
asked Select multiple objects on top of simlanes
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
awarded  Scholar
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!