shift column values via macro

Hi there,

I was hoping if someone can help me out. I am trying to copy/paste a bunch of data into excel. After I paste it to excel I need to delete one column or in other words, shift all the data to the left by one column (please see attached example file to understand fully). The number of columns and headings of columns remains the same just the number of rows change. Please see attached excel file for illustration. any help would be appreciated. thnx

regards,

SnK