OK - sorted the date/weeks problem 🙂 - Instead of applying the function to each cell in the range, put it in the first cell and autofill! Same with t...
Once again, thank you very much, Sunny. Absolute genius, and a blessing to have around! I used your Insert Formula row, with the ColLetter variable...
Thanks Sunny - I've got a slight variation on setting the 'FinalRow' variable ... FinalRow = Cells(Rows.Count, 5).End(xlUp).Row. Before I set it as a ...
Hi Sunny, I've had a play with your code and written something that is doing roughly what I was thinking of for he Building Codes. Hopefully not to...
Thanks Sunny, It wasn't quite what I was after but I can see how that is working, using an input for the cell comparison and the second input for t...
Hi Sunny, Trying to get the various bits of data in - Column C has 16 options - but each building that has been tested (for portable appliance elec...
Hi Sunny, 2nd attempt at a reply - working remotely and trying to load it I was getting JSON parse errors when I tried to upload, so resorted to em...
Hi, I'm using the following, for a fixed number of columns (but you can also add in a variable for the last column). I've got a Public variable 'Fi...
Many thanks, Sunny - I've tested on a copy of live data, and all looks great, including week 1, weeks in term 3, and the various oddball combinations ...
Oops! Not quite ... I've found several results which do not come true ... I feared that this was somewhat more complex due to the nature of the data! ...
Brilliant, many thanks, Canapone ... that is exactly what I am looking for! It works superbly on the sample, and also on a single row in the (copy of)...
Hi Sunny, I've added two extra columns to the original file.Column J shows the desired result from the calculation of the number of weeks, and Colu...