Hi,

I need to format an amount of data using VBA as a beginner.

I need to copy rows from Sheet1 to Sheet2 another based on cell criteria i.e.

If cell N2 contains data I need to repeat this row 3 times on Sheet 2
If cell M2 contains data I need to repeat this row twice on Sheet 2
If cell M2 contains data I need to repeat this row once on Sheet 2

I need this to continue down all the rows to the end.

I presume I will need some sort of loop which will need to count the number of rows as they will change on a monthly basis.

Thanks in advance.