Hi Catalin This is the file I was using to test your macro. If the slicers were disconnected before running the macro, they fail to get reconnec...
Hi Catalin The code doesn't seem to reconnect back the slicers.
Hi Hooi Thin See if this helps. It will only work if you have unique months/year as the date field. I am unable to hide the blank in the slicer ...
Hi Cindy Your data is a bit more complicated (and dangerous) to delete due to the blank rows on top and hidden columns that also contains data. ...
Hi mey I believe you are not getting an answer because no one understood what you wanted. Even the example file is not helpful as you did not show ...
Hi Baker Without seeing some sample data, it is difficult to determine where the zero values are. If they are all in a single column then you can g...
Hi Hooi Thin I am not aware of any method that you can hide a field with affecting the PivotTable. Maybe you can just hide the entire column ins...
Hi Holly You will need to pad the number with leading zero(s). Example F-01-052917 F-10-052917 Sunny
Hi Maurizio Your calendar on the userform is not accurate as the complete days are not shown. I did not modify this for you as I don't understand y...
Hi Diane Maybe I misunderstood your request as I thought you wanted a 1 if the effective date is > 6 months. I too was wondering earlier why you...
Try this then in cell R2 =IF(K2<>"","",IF(OR(TODAY()>=EDATE(H2,6),TODAY()>=EDATE(K2,6)),1,"")) Sunny
Hi rdawbrey Give this a try =IF(OR(L2="",L2="void"),"",IF(OR(TODAY()>=EDATE(I2,6),TODAY()>=EDATE(L2,6)),1,"")) In future it would be he...
Hi Dritani See if this helps. I have included 2 examples (Advanced Filter and Array Formula) Sunny
Hi Hooi Thin The best that I can think of is to create a helper column in your source data that will allow a unique grouping without affecting the ...
Hi David Rachael did ask for a formula in her post. "Can anyone help me with a formula to extract non blank cells from a row." That is why Ca...