You will need a macro to do this, but you will need to specify far
more details about your sheet, layout and data ranges etc before
anyone would attempt it.

Pete

On Apr 18, 11:43*pm, WRC wrote:
I have table with month wise data for 3 years in column,s & data in row.

I have a cell out side the table were I will specifiy the date (month-year).

I want the data to be deleted from 1st month to month specified above and
move cells left and populate the right cells with "0".

Thanks
Raj