Copy cells in a row

Hi

I'm trying to copy a row with hidden cells to another sheet which i managed to do. But there is one problem that i cant solve. I dont know how to copy cells into a different order.

Let me explain:
Cell A1 in sheet1 should be copied to cell A3 in sheet2(to the first empty row).
Cell A2 in sheet1 should be copied to cell A1 in sheet2(to the first empty row).
Cell A3 in sheet1 should be copied to cell A4 in sheet2(to the first empty row).
All cells should be copied including to hidden ones.
The user should only hav to mark which row it is the click a button to copy.

I hope you understood the above.

Cheers Johan

Hi Johan,

Please check wheither this works for you.......you simply reference an cell.Let me know if you need it in a macro.



Regards,
Shekar.