Printable View
Hi,
I'm currenlty try to create a macro that takes all data in a set number of columns and paste it below each other. I want it to loop this until last populated column.
The number of rows in the sheet can change but is around 300- 400.
Current
ABC111222333444555
ABC111222333444555
End Result
ABC111
ABC111
ABC222
ABC222
ABC333
ABC333
ABC444
ABC444
ABC555
ABC555
Any help would be highly appricated.
Thanks
Hi TommyKris,
welcome to ExcelFox!!
Could you attach a workbook ?
Attached workbook.
What i'm trying to achive is that starting from column AC i want every 14 columns to to be copies and pasted in at first empty row in range O:AB. Macro shoud run all columns until first empty column.
Anyone??
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwhVTFaD469mW9wO194AaABAg. 9gJzxwFcnPU9gORqKw5tW_
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugyb8nmKKoXvcdM58gV4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwvvXcl1oa79xS7BAV4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgxvIFArksPprylHXYZ4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA