I have a sheet and in a cell you enter a certain date, let’s say cell A (yes I know there would usually be a number too!) I want rows to hide or be visible based on how that date relates to another date in a cell on another tab, let’s say cell B.
Both are open cells and anything, within reason, can be entered.
if A is greater than B then rows 33 and 34 need to be visible, if A is greater than (B+14) then rows 33 to 36 need to be visible, if A is less than (B-30) then rows 31 and 32 need to be visible and for everything else (which is if A is blank or less than B but nor more than 30 less) rows 31 to 36 are hidden.
im not precious about having cell B from the other tab duplicated in one of the columns on the same sheet as A, or naming cells, and have tried putting the result of B, B-30 and B+14 in 3 cells on the same tab as cell A, but I can’t figure the code to say if A is greater or less than these 3 cells.
I have probably hundreds, certainly dozens, of if case equals x then true or false hide rows. and they are all working great, it’s just the greater or less than part that I’m struggling with.
any Help would be massively appreciated, I’ve been working on this project for ages and am finally close to finishing and this last bit has me completely stumped.
Both are open cells and anything, within reason, can be entered.
if A is greater than B then rows 33 and 34 need to be visible, if A is greater than (B+14) then rows 33 to 36 need to be visible, if A is less than (B-30) then rows 31 and 32 need to be visible and for everything else (which is if A is blank or less than B but nor more than 30 less) rows 31 to 36 are hidden.
im not precious about having cell B from the other tab duplicated in one of the columns on the same sheet as A, or naming cells, and have tried putting the result of B, B-30 and B+14 in 3 cells on the same tab as cell A, but I can’t figure the code to say if A is greater or less than these 3 cells.
I have probably hundreds, certainly dozens, of if case equals x then true or false hide rows. and they are all working great, it’s just the greater or less than part that I’m struggling with.
any Help would be massively appreciated, I’ve been working on this project for ages and am finally close to finishing and this last bit has me completely stumped.
