This has been working brilliantly for over a year - props to Luke for the code.
My requirements have changed a little now and instead of a .pdf of the active sheet I would like it to save as a workbook in .xlsx format- is there a tweak to this code that can change the file type? I did some...
You might have to enable 'searching within files' on the folders you keep your workbooks in, also indexing those locations will make the searching faster.
Hello all,
I need some help to see if what I am trying to do is possible and if so how. I am summarising/calculating information from our 'raw' data to be the back end of a dashboard display. All the data for the DB needs to be in the same table to facilitate slicers working across all charts...
@Somendra Misra and @ThrottleWorks , thank you both for your input and solutions.
It looks like I was just a couple of iterations away from your solution Somendra- it has been a long day with many problems so I was perhaps too keen in giving upn and asking on here!
Excel inner peace has been...
structure example attached Somendra.
@ThrottleWorks it works partially, I can see how the helper colum works and how the CF should apply however if I can avoid helper columns that would be good and also the application of the CF in your example does not work as it should (this may be a a...
Hi all,
Could someone please help me with a formula for conditional formatting?
I need to format the whole row based on a date, whereby if the date in column BI is within a week either side of today's date (which is fixed on another sheet in cell 'Legend and Pivots'!D1) the text of the row is...
If I am missing something very simple, please don't shoot me!
Need to change this:
2014-01-03 12:53:21 +0000
To be like this:
03/01/2014
For about 10,000 rows.
I have tried formatting the cells to no avail and have managed by using something like -=LEFT(A34,LEN(A34)-13) to remove the...
Afternoon Excelentrics
I have rather spiffing dashboard with multiple slicers controlling multiple pivot tables, so far so good. All pivot tables are based on the same source data hence the slicers working on them.
I would now like to introduce a new data source (independently generated...
I don't think this answers your question regarding benchmarking a consolidated KPI, however the page below shows a pretty nifty dboard Chandoo put together for a call centre type environment- it makes it pretty easy to visualise various KPIs on one page rather than consolidating...