hidden rows and autofill troubles
 

Within the same workbook i am trying to have statements written in one row on a worksheet autofill another row on a different worksheet (same workbook). the problem becomes that i occasionally need to hide rows and when those rows are hidden i don't want the statement displayed in the other "autofilled" worksheet. any help would be appreciated.
thanks