Hi there,
I have been cracking my head on how shld i know the task below. I also just started to learn vba and thats y my head crack.
I need to format a set of data into a specified number of columns. Say for example in Range R25:E16, starting from E5 to LC i have 12 columns. I need to format the Range into 6columns, then insert new row, cut and paste the remain 6columns.
I have upload the example to box net. Pls kindly take a look.
http://www.box.net/shared/dxq9kaormmjaqfiy740h
This is so far what i figure out. i need to use vBa to check each row if the condition columns.count is more than 6. If False then go next row. if true ...< do i use do until loop here? >.
Really need some advise here.
Thank you.
Regards
Edmund
I have been cracking my head on how shld i know the task below. I also just started to learn vba and thats y my head crack.
I need to format a set of data into a specified number of columns. Say for example in Range R25:E16, starting from E5 to LC i have 12 columns. I need to format the Range into 6columns, then insert new row, cut and paste the remain 6columns.
I have upload the example to box net. Pls kindly take a look.
http://www.box.net/shared/dxq9kaormmjaqfiy740h
This is so far what i figure out. i need to use vBa to check each row if the condition columns.count is more than 6. If False then go next row. if true ...< do i use do until loop here? >.
Really need some advise here.
Thank you.
Regards
Edmund
