Hello everyone. Hope you are all well and safe.
Here is my dilemma. I need to hide rows after a value is entered. All the code I have seen posted here will hide every row after a cell entry is made. What I need is, if I add a date in column "E" next to the name Bill like in the picture, I want every row with the name Bill in column "D" to be hidden EXCEPT the row with the date. Later if I add a date in column "E" next to the name Gus, all the rows with Gus, except the row with the date, will be hidden. Once the date is added in column "E" that name will never be added to the list again. So, I won't have to worry about hiding future entries with that name.
The name here is generic. There will be first, last and maybe middle names as well. I don't know if it matters, but all the entries in columns A-D are auto filled by entries in other workbooks. the only manual entry is the date in column "E". Hope this
Thank you in advance,
Jim
Here is my dilemma. I need to hide rows after a value is entered. All the code I have seen posted here will hide every row after a cell entry is made. What I need is, if I add a date in column "E" next to the name Bill like in the picture, I want every row with the name Bill in column "D" to be hidden EXCEPT the row with the date. Later if I add a date in column "E" next to the name Gus, all the rows with Gus, except the row with the date, will be hidden. Once the date is added in column "E" that name will never be added to the list again. So, I won't have to worry about hiding future entries with that name.
The name here is generic. There will be first, last and maybe middle names as well. I don't know if it matters, but all the entries in columns A-D are auto filled by entries in other workbooks. the only manual entry is the date in column "E". Hope this
Thank you in advance,
Jim