Try the attached Dates can be a bit moody in Excel access location but i think it should be okay as i am filtering on numbers Purfleet Option...
To clarify? if the reference only appears once = Nothing if the reference appears twice on the same date = 1 if the reference appears twice on dif...
Messy and with too many helper columns but seems to come out with the total minutes in column H, which can be filtered for less than 5. I am sure o...
Looks like number formatting will only use normal rounding and you cant add in any INT or rounddown function. As a work around you could create a l...
So you dont really need to know the last charecter of the Percentage, we can just do a calucation on it? Are you sure that the person getting >9...
Brilliant - looks good and is very satisfying when you can get it to work (and very frustrating when you can’t!)
Sorry missed that bit #0, Purfleet
You want to see the number rounded down to the nearst 1000 and only show the thousands, but the real number is still in the cell? Worth having a re...
Yes, thinking about it you would add the numbers and then run the macro whereas I was thinking it would be the other way away, which is a bit stupid i...
Very small data set to show how it works and the Greater Montreal heading had the word 'Area' missing which caused a problem! In my opinion Index/M...
Hi Robert Combobox I have not had any experience with the Combo box so not sure why it is appearing on other sheets - i would guess it is a reso...
try the attached The full file path goes in B1 and then Yes or No if you want to copy headers over or not Purfleet
With your data in Column A try Sub NumEx() Dim r As Range Dim c As Range Dim i As Integer Dim Temp As String Dim o As String Set r = Ran...
Hi Charlton I take it all the sheets will be in the one workbook? what range is being filtered the options worksheet or the master? Will you want ...
Going to need a bit more info to be able to help! What type of files are they? do they all have the same data? seperate files or 1 work book? Pl...