Copy-paste dir.

[a.janmohammadi]

Hi
How can I copy-paste a set of cells in ONE row (in a left-to-right sheet) to another row (in a right-to-left sheet) but without changing the direction of the original set of cells?

example: My cells are A1:F1 (in the left-to-right sheet). I want them copied in F1:A1 (in the right-to-left sheet).

THX

[jason.b75]

Can't be done with copy and paste, but can be done with a formula, (then, if desired, copy and pastespecial to replace the formulas with the results) or with vba.

Assuming that the left to right sheet is Sheet1, enter this formula in A1 of the other sheet, then drag it to F1.

=INDEX(Sheet1!$A1:$F1,COLUMNS(A1:$F1))