Search results

Many thanks Deepak!

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...

screencap attached this time.

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...

Fantastic, didn't think to use the TEXT function. Need to engage my brain. Thank you very much Abdul!

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...

Had a thought- is it possible to have a cell populated by the text of a highlighted slicer option?

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...

IT'S A FORMULA WALK OFF!

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...

Mods/Ninjas is there a way to alter the thread title with [SOLVED]?

I don't know of a way to make data validation auto-suggest based on initial text input. you can use the dropdown menu to show the list contents- do you have too many list items for this to be practical. I would add that the lack of response may have something to do with perceived attitude in...

Hello

Chaps- thank you very much. Since posting I put in a workaround by having a helper column =IF(COUNTIF(Talent!$A:$A,'Retail Master'!$E2)>1,"Y","N") and then based the CF on that. I am running it down 6000 rows so I don't think it will slow the calculation time of the sheet by too much. I am...

Afternoon followers of Chandooism, I'm stumped again on solving a problem, even 6 cups of tea in a two hour period has not helped me. I have a table of data that I would like to apply conditional formatting to. I would like, when people enter a location (4 digit code), for the whole row to be...

Cheers Luke, if I know the range of cells that from the page, e.g. A1:K30 is there another line I can put in to make that the 'active sheet' for the save. It is always awesome to see how clean the VBA can be if you know what you are doing- I usually search for the different components or...

Excel warriors, A cheeky request for a bit of scripting- could anyone please provide me with VBA code to save the current active sheet as a .pdf in a defined network drive, and for the name of the file to be a combination of the text in cells A1 A2 and A3? I have managed through recording a...

I have found that some links can be really stubborn and do not break through the normal excel command. The find link add-in by Bill Manville on this page can be useful: http://www.oaltd.co.uk/MVP/Default.htm

SIrJB7- thank you, now I see the logic and it works. Cheers guys problem solved.

When I separate it and just do the SEARCH it returns a value of 1, can I make my logical test SEARCH(("*Advisor*",B2)=1)? Will try that now. Cheers HUI

Afternoon all, currently having trouble nesting the above functions to return the result I want. I have a column with job tiles in it, there are three job titles though a couple of instances for each e.g. Trainee Customer Advisor and Customer Advisor, Assistant Manager and Customer Service...