Hi Everyone,

I know how to copy or populate the same cell (or array) in multiple sheets. I am wondering if there is a way to paste that data in ONE sheet. For instance you have a record R1 in cell C2 of Sheet1, R2 in cell C2 of Sheet2 and so on to Rn in cell C2 of Sheetn. You copied all simultaneously and now you want to past your data in Sheet1 across the range H1:Z1. so that R1 goes in H1 and R2 goes in I2....

can any one help please?