Produce multiple results after searching a value

I've watched a video about this topic but the formulas were just confusing and doesn't seem to fit the database I'm working with. I'm trying VBA as I have knowledge of general programming but I'm very new to VB. This is what I have so far after a few days:

Please Login or Register  to view this content.

What I'm trying to do is search for the user's input on A2 in Sheet2 and write the values correlating to A2 starting at row 8 in Sheet1. Because there may or may not have multiple results, the loop will search the entire column Table1[Item] until all A2 matches are found and written into Sheet1. I'm sincerely sorry for the mass mistakes in the codelet It's been days...Can someone guide me on this new grounds of VBA Excel? I really appreciate this.

Hi..

It will be far better if you post (attach) a sample Workbook..