I have data range say A1:G10000 (this varies each month)
Row 1 has column headings
Column E is always blank except for the column heading in E1


Each time I filter column D I wish to copy a certain same text in each of the visible blank rows in the adjacent column E using VBA



Can someone please help.