In my opinion, it would help if you gave a better description of your data. From what you've written, it seems that you have three sheets: (a) Active, (b) Application, and (c) Output. And you want to copy data from Active to both Application and Output. In the Active sheet you have six columns of data: "Office", "Account", "AT", "Journal", "Sign" and "Desc". What do the columns in Application & Output look like and how do you want the data copied?