I have a excel sheet which has many colums
Srl No Name Age Address City State Country
Many time i need to take reports in different ways so is there a way to shift these colums according to my requirement.Any inbuilt way or a macro to change according to my input.
Say a macro asks 1st colum .I say 3 and next 4 and then 1 so on.
This would run until all colums get over.