Copy rows based on value

[Umair.711]

I have a bill for customer. TO record bills I have two sheets. One store Bill number. Order Number, date, customer, total quantity, total amount.
Another sheet say RECORD store Bill number, date, customer name and goods details from bill.
I have dedicated 17 rows (R13-29) and 5 columns (C2-C6) for goods in bill. But I want to store only rows with data. Lets say I have 5 goods in bill,
so i want to copy contents of R13-R17 data in record sheet from 4 column and onwards. First three columns of that sheet store bill number, date and customer name.

bill.xlsx

[Vidya Palani]

Try this and let me know if it helps.

Please Login or Register  to view this content.

[Umair.711]

It can copy cells with data. but it doesn't insert new rows above. Also the bill number dragging is for 3 cells. My requirement needs an if statement. I know its simple. I just don't understand how to handle loop for that.

[Vidya Palani]

Insert rows where? Can you elaborate?

[jaslake]

Hi Umair.711

If I understand your requirements this Code may help.

Please Login or Register  to view this content.

[Umair.711]

Hi Umair.711

If I understand your requirements this Code may help.

Please Login or Register  to view this content.

Got it. Thanks . It worked perfectly

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save