When a search term appears in column I, copy the value from column H to a new cell.

Elaborated:

Need a macro to go through a column (I) and everytime a search term appears, it copies the contents of a cell from the same row different column (H) to a new location. (new sheet?)

for example:

The word "Banana" appears in I25. In H25 is the word "Car". The word "Car" is copied to a different sheet in A1. The next time "Banana" appears in column I, the corresponding value from H is copied to A2. When it has finished cycling through, a list has been created consisting of all the H values when a specific term appeared in Column I.

I have worked on this for a while and can't get far. I'm not very good with excel. I need to use this macro for a bunch of different terms and have quite a bit of data gathering to do, but can't get started.

Any help is greatly appreciated.
Thanks

This is for LibreOffice, and with that code I get a syntax error: "unknown data type range"

I tried it on my friend's laptop and get an error. "Compile error: expected end of statement"

Run-time error '9'"
Subscript out of range

If i hit "debug" it highlights the third line.


thanks for all your help with this

canadian army and sheet 1

oh, woops. I thought the sheet1 and sheet2 just referred tot he place the files are, not the actual file names. Thats got it working now. thanks for your help!

@ ShallowJamm

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

I am aware of all of these things, thank you. I was waiting to see if WasWodge was going to reply.