Generate rows in respect of values of a column

I have values in column E of my workbook

i want to generate rows for its corresponding f g h and m column in sheet 2

attaching a sample sheet also kindly assisst.

regards

The code works on the sample attached. Make sure that you have the word "Month" next to month.

The code is working fine sir

but the problem is it is generating a new sheet everytime where as i want to generate the result in existing sheet2 only and if sheet2 is full it should generate result after clearing data of sheet2
as further the results are linked with sheet2 only....in my workbook

If you do not want to clear the existing data before the code copies in the sheet, you need to remove (Comment) this line.

.UsedRange.Offset(0).ClearContents

Thank you sir...

the code is generating rows for those columns also where repestive values aginst code is zero also which is not require

if any column is blank or zero then the code should not generate a row against the code value column

kindly modify the code

the code is generating rows for those columns also where repestive values aginst code is zero also which is not require

if any column is blank or zero then the code should not generate a row against the code value column

kindly modify the code

Try

Please Login or Register  to view this content.