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: http://imgur.com/Mg2cU3R
My output columns Imgur: http://imgur.com/CcVFhap
Bookmarks