Hi, I have a spreadsheet I developed with a few macros for our local Sheep Dog Trial club. I’m now wanting to elevate it to a more user friendly application so I can offer it to other clubs.
I have a section where I’m unsure how to fix and wonder if you could suggest an approach ?
I have a cell with a date e.g. 27/1/2012 and another cell with time 6:00:00 a.m. I want to combine these two cell references into a combined cell, this combined cell is then used in a countif function as the "criteria" i.e. <27/01/2012 6:00:00 a.m.
I already have a custom number field with this working BUT I want to write a macro that automates the user process of updating of the date cell annually and the criteria cells of which I have 8 each with a differing time block like the example above. So I'm wanting to try to reference the date part rather than manually edit each of these 8 criteria cells as I do now. I hope this makes sense. Apologises if not clear.