Entered a new column, successfully modified results but has one issue

[valentin.nicolae]

Hi,

It's a billing exel with automatic report, using macro.

The remaining issue is that after i press macro command "Adauga date in raport" from "Factura" sheet, it adds to "Raport" sheet 30 lines of result instead only the lines that are filled in.

What i modified:
Added new B column in "Factura" sheet.

Please find attatched updated document.
The expected result is to autocomplete, in "Factura" sheet, with data only from the line 17.

Original macro script

Please Login or Register  to view this content.

Need help,
Big thank you

[buran]

There is no attached workbook, so I don't have a clue how your file looks like, but look at follwing code that you have

Please Login or Register  to view this content.

you find the last tow in sheet Factura (assuming it's before row 47) and I guess it's line 46. Then you loop over all rows 17-46 (exactly 30) and copy all these 30 rows to worksheet Raport. If you want just row 17 don't loop over all these rows, just use lrow=17 or directly use 17 in the Range address

[valentin.nicolae]

Hi,

I remember attaching the file.
Tried again to reattach, hope al good. I'll also provide it differently, here it is: https://drive.google.com/open?id=1Aj...8fYZST8KI_AYgR

Picture this, the billing report (macro command) is supposed to enter in the raport all de lines filled in with data, from row 17 to 47. Only the lines filled in with data. Sometimes only one line (row 17) is filled with data, somethimes 4 lines (rows 17 to 20).
Previously, the report filled in correctly, only the lines with data, now enters what you see in the attatchment.

Please help fix the script.

Thank you

P.S. Seems notification when i receive reply to this thread is on, but no notification. Sorry for such a long delay for a response, i just remembered to check if someone replyed. Thank you