copy and arrange cells

[ccsmith]

I would need some support to create a VBA for the follwoing task. (see my uploaded sample file).
In columns from A to J I enter the data continously in more rows.
Runing the macro need to
- copy the data in columns A-D-C-D (data in each row as far as the last entry) to columns L-M-N-O
- then copy columns A-E-F-G (data in each row as far as the last entry) into column L-M-N-O but after the row contains the last data,
- then copy columns A-H-I-J (data in each row as far as the last entry) into column L-M-N-O but after the row contains the last data,
finaly sorting the columns L-M-N-O in ascending order by columns M,N and O.

[rethguals]

Check this code..

Please Login or Register  to view this content.

[ccsmith]

rethguals: Thank you. You solved it. I am very grateful.

[ccsmith]

rethguals: Could you modify the macro to copy just the values (without formulas, formating etc.)?

[rethguals]

Hi..
Please check below

Please Login or Register  to view this content.

[ccsmith]

Thank you.