Table problem

[WRC]

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

 

[Pete_UK]

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