Excel Macro Loops, Copy, Paste

Hi I need your help, I'll try and make this as clear as I can.

So I have two sheets, Sheet1 Sheet1.JPG and Sheet 2 Sheet2.JPG. For each item there is a corresponding ID.
Apple is 1, Orange is 2 and so on and so forth.

What I need to do is to create a macro that will go through the ID in Column A - Sheet 1 and then paste only the matching ID's in Column B - Sheet 2.

So for example on Sheet 1 - Column A, ID no. 1, the Item is Apple, the code will go through the ID column and read that for the ID no. 1 the item is Apple,

and then it will paste the Item "Apple" beside the ID no. 1 in Sheet 2 because the ID 1 is for the item Apple.

I hope that was clear.

Thank You

"An attached book is worth millions of words". Not a lot we can do with a picture

Ok here's the uploaded sample workbook.

myownworld,
I would not recommend using a code for this simple task which could be easily done by Excel's VLookup or match and index functions, but if you insist you want a code, see attached

Wow. You guys reply fast. This really helped.

Thank You so much!

myownworld,
You are welcome!

myownworld,
Once a thread has been closed and if you have any new request, you need to post it as a new thread, otherwise, it will be open until eternity.
See attached.

ok thank you AB33 i'll just post a new thread regarding this new inquiry

myownworld,
Did not you my last attached answer your request?

it's not exactly what i was looking for, cause when i tried to run the macro what happened was it kind of doubled the items, if you look at sheet 3 the apple count was only 30 then when i run the macro the count of the apple became 132, the same with the other items.

and the for the other items they start with a different item number not all of it starts with 10 and ends with 39, that's only for the apple, there's a different item number for the items.

myownworld,
Sorry!
I did not see you had a gap on your data, so my current region only picked up values up to row 31. I will correct it in a minute, but need to ask you again. You want to return the value from sheet3, column C in to sheet 4 ,column C when match is found. Is this right?

Yes that's right, I attached another workbook and added another tab so you can check out what it should look life after.

Thank You so much!

Yeeeeess! That's how I want it :D Just one more though, I re-run the macro again but how come the banana item was cut down to one, the other 8 got deleted?

See attached abve

i did, what i did was i cleared the items on Sheet 4 - Column C and then I re-run the macro and then I noticed that the last row became 111 instead of 119. the other 8 banana item got deleted..

Myownworld,
I know what the issue is. The loop had stopped at row 19 in sheet 3, so the code did not look beyond it. See the attached works better.

Got it now, thank you so much AB33!

Got it now, thank you so much AB33!

Hi again, i know i already marked this thread as solved then i marked it again as unsolved cause i can't edit the code you gave, it's just too advance for me

could you please help me again, i attached the workbook, it's exactly how it looks like on the original one that i'm working on, i should've done this the first time sorry, i hope you could help me again thanks so much