I have put a coulm called month on sheet 2 and 3, where the raw data is pasted and then on sheet 1 i have a cell where i insert the list for 1 -12 months, after selecting the value for eg 9 month and run the macro it will show the values for the month of 9