I have tried that it works if you are going down a column but i want to go across columns ie. sheet 1 a1,a2,a3,a4,etc to show in sheet 2 b1,c1,d1,e1 etc without having to copy each one at a time as it may go to sheet 1 a???.