If i am understanding correctly you get over time at 1.5 hours for anything over 48, but also anything over midday on saturday is double time? If s...
I actually do agree with Velouria - you really shouldnt be calculating anything on a cell format. To my knowledge you cant use ranges with the Cell &...
R S said Hello Purfleet, Thanks so much for your response. I tried running this but the macro did not produce a result, though it did not require...
A couple of things to note - - the drop downs dont work as you have not added the sheets the validation is on so i cant check in great detail - i a...
You need the Cell function Try this blog by Mynda You will need to reference back to the blog as the output are kind of codes, but they will...
I have used something like the below a few times, it is formatted for my test textfiles and copies to the sheet 2 of the Macro workbook - you can then...
Velouria said If your data is sorted like the sample, and you don't mind the consecutive totals appearing at the end of the sequence rather than the ...
You would need to recreate the formula's referencing the second sheet, or as a work around, paste on to a new sheet and 'paste as link' from there you...
Its still not particularly clear as the we cant see the actual workbook, but something like this might work. You need to create this sub in the Thi...
Hi Sean Glad it is working - i have found with vba that it is often the most simple things that cause the code to break - i once spent an hour try...
The layout of the data isnt great, but i have knocked up the attached with a few helper columns (these can probaly be consolidated at some point) and ...
How are you putting the DeleteRow Sub in the existing ? are you pasting the whole code into a certain part of your existing code?? I noticed that ...
Sorry didn’t think about employee - the attached fixes that issue. We could extend the formula to work for 3 occurrences, but then I suppose 4 are po...
it looks like you have the worksheets protected so the macro cant delete anything. you can get the macro to unprotect the work sheet by adding acti...
Try the attached. It is assuming that the rows showing the overlapping dates would be in order. Column F =IF(B2=A3-1,"Con","Not"). Checking if...