loop execution not perfect

Welcome to the Forum ajitvyas!

Please tell us:

1. How to run the macro that has the problem
2. What you want the macro to do
3. What it does instead (that is, what is not perfect? What is the problem?)

Dear sir,
thanks for answering me, i wish to copy value of range from frm table sheet paste the same in farmer bill sheet below the head of amount, qty rate and buyer name as i entered invoice no in cell b9 in farmer bill entered
for example if i entered invoice no 570 in b9 cell for farmer bill sheet, it should fetch the invoice no 570 related data from frm table .if there are two times of 570 then all the two times record should be paste.
my code does work one time(one line of data it does not took another 570 no in counts.
it is still in developing stage you can f5 switch to run the macro
open module 4 this code

can you solve it ?
thanks in advance

I think this does what you want.

Please Login or Register  to view this content.

Another Option...

Please Login or Register  to view this content.

thanks all for replying me , i am out of station and i will applying these help when i reach my office mean while

following is code that i made this work one time only
i wish all you will see this and correct it
thanks again
ajit vyas

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however we recommend that you include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I have added them for you because you are new.

code work properly and gives result as i want

Glad to have contributed...tx for rep +

i do not understand some lines but it works nice
if you provide some knoledge last three line it will be more oblige me

Please Login or Register  to view this content.

Here And Here is some info...

ajitvyas. I don't quite understand you. Could you explain it more precisely?
See the attachment. Everything seems to be working fine to me.

After copying the code to the VBA module, go to the 'farmerbill' sheet --> left Alt + F8 --> run the 'billmake_maras' macro.

maras_mak's code works for me...