Hey there,
What I have is an excel spreadsheet that gets exported out pretty ugly. What I am hoping to do is for VBA (or other suggestion?) to look down a colum and if there is data there grab what is there and to the right of it and move down a row. (hope that is good enough explanation) I am going to include a sample file to help explain.
So Look down colum F if data grab what is in colum F, G, H, I and move it down 1 row and to the left but to leave column E.. So F1,G1,H1,I1 would get moved down to A2,B2,C2,D2 and so on.

If any one can lead me in the right direction you will be such a big help.. Thanks


Export Sample.xls