I have a VBA problem that i have been trying to figure out for a few days. In Sheet1 i have data range from C5:AZ90. I want to copy a column and paste it into the column before it and clearcontents on the column that was originally copied. I have created a vba which does one column at a time and that is not dynamic at all.
copy D5:D90 and paste it in C5:C90 and clear D5:D90
copy f5:f90 and paste it in e5:e90 and clear f5:f90
copy h5:h90 and paste it in g5:g90 and clear h5:h90
And I want to do that for all the columns up to AZ
Any help is much appreciated.