How do you add data into a hidden row? You can do what you want with VBA code using a WorkSheet event