Need to make a macro to find values in a table column, pictures included

[smithian91]

This is my first post here, please be gentle

I need to make a VBA macro to search through a table column and find values that are greater than the value of a single-cell named range (my threshold in this case). Once I've found a match I need to copy the contents of a cell on the same row from the Dest. Handling Unit column as the match to the HU column of the second table.

Part of the complication of this macro (for me at least) is that I need the results to be put in the output column one after another, not just written over and over in the first cell of the column.

I've provided pictures of the two tables below.



My source columns Imgur: The most awesome images on the Internet
My output columns Imgur: The most awesome images on the Internet

 

[hiker95]

smithian91,

Welcome to the MrExcel forum.

I've provided pictures of the two tables below.

Anyone trying to help you would have to enter the information manually into a workbook/worksheet(s)?????


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


If you are not able to provide screenshots, then:

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com