Hi,
Is there anyone who could help me with one macro? This is the format of the data:
And this is what I would like to have at the end:
So basically I need a macro that would copy column D&E and put the data below B&C, also copying tasks respectively. and then the same for all other columns. The problem is that the number of columns varies... sometimes it's 30, sometimes it's much more.
Is there anyone who could help me with one macro? This is the format of the data:
![picture1.jpg](/board/proxy.php?image=http%3A%2F%2Fforums.techguy.org%2Fattachments%2F174262d1278661993%2Fpicture1.jpg&hash=6b3599e7b1063942d40fe3ef87dc940f)
And this is what I would like to have at the end:
![picture2.jpg](/board/proxy.php?image=http%3A%2F%2Fforums.techguy.org%2Fattachments%2F174263d1278662004%2Fpicture2.jpg&hash=f4debe53186bb2c87fe98fa1be085cb6)
So basically I need a macro that would copy column D&E and put the data below B&C, also copying tasks respectively. and then the same for all other columns. The problem is that the number of columns varies... sometimes it's 30, sometimes it's much more.