Hi

We just want the item 4 ,5,6 can move to anthoer column as
my attached name "final" files from the named "original" files . Sheet1 name "original" and sheet 2 name "final" automatically.

how to write the vba code ? (that is the programme run when meet item 4,5,6 then the programme can cut and paste the item4,5,6 information to another column)because number of item 1,2,3,4,5,6 will change from time to time(that is the total number of rows will change from time to time). but the item number 1,2,3,4,5,6 will not change

Thanks
Tomlam

Attached Files

dd.xls (22.5 KB, 9 views)