Pls. reply Sort Data and copy to next coulmn when sort order chang

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.

Shital 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


"shital shah" <shitalshah@discussions.microsoft.com> wrote in message
news:D7168751-91E4-4DAD-A141-184AFC43B417@microsoft.com...
> 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.
>
> Shital Shah
>
>