I have a report that needs to be imported into excel from a text file and
formatted daily. I would like to automate the formatting process with a
macro, unfortunately, my VBA skills are not very good.

Could one of you please help me with the macro?

I think what I need it to do should be fairly simple.

If the cell in column e is blank then I want cells a, b, c, and d
(respectively) to all move one cell to the right. This should be be applied
to the entire set of data (usually about 350 rows)

Thats it.

Thanks in advance,
DIane