Hello
I am entering date wise data into worksheet for every date of data I have
new worksheet now I want to sort all worksheet together as per column €œA€� and
then after all sorted item of column €œA€� has to set next column after sorting
order is change.

For E.g. after sorting A wise when B come it should transfer to next column.
I have 5 field (heading) i.e. when sorting order is change it should copy to
next column i.e. column no. 6

Any help.

****al Shah

What gets copied to the next column? Column A

' code to sort then
columns(1).copy Cells(1,256).End(xltoLeft)(1,2).EntireColumn

--
Regards,
Tom Ogilvy


"****al shah" wrote in message
...
Hello
I am entering date wise data into worksheet for every date of data I have
new worksheet now I want to sort all worksheet together as per column "A"
and
then after all sorted item of column "A" has to set next column after
sorting
order is change.

For E.g. after sorting A wise when B come it should transfer to next
column.
I have 5 field (heading) i.e. when sorting order is change it should copy
to
next column i.e. column no. 6

Any help.

****al Shah