I'm sorry I don't know VBA that well. If I have a template, how can I tell it to be filled from the various rows of data on the other sheet? For example, on the template, the cell range A2:H2 (a merged cell) must equal B4 on the first sheet, then B5, B6, and so on. And Cell F9 on the template must equal E4 on the first sheet, then E5, E6, and so on.