Split data as per quantity

[rchure]

Hi Team,

Need macro help in attached report.

As per column F "Quantity (Nos.)" the rows should be added in below and all data copy as it is in below rows except amount columns "K,L,M,O & P" for this amounts columns amount divided equally as per qty. Row only added if quantity more than 1.

Ex. In attached report for first entry the qty is 4 so I have included 4 rows in below and in amount columns (K,L,M,O & P) divided by 4 in each line.


Hope you have understand my query.

Thanks for the help in advance!!

[Mumps1]

Try:

Please Login or Register  to view this content.

[JLGWhiz]

Try this

Please Login or Register  to view this content.

[rchure]

Thank You Sooooooooooooooo much!!!

Your VBA macro code help me a lot and save my lot of manual work.

Thanks once again

[Mumps1]

Glad to help.