Hey,
Long title I know, but this is pretty specific. Take a look at the example worksheet attached to get an idea of what I'm trying to do. The ranges are essentially defined by all data between each instance of the symbol $. Within those ranges, sometimes the number 12 will appear in Column D. These are the ranges I'm interested in. When I find ranges with "12" somewhere in column D (other things can be in the cell with 12, just as long as 12 is there), then I want to pull the value of the first cell above that with $. Sheet2 of the worksheet attached demonstrates how it should look once the macro is run (note that lederho$en doesn't get pulled because there's no 12 in column D of that range). I can think of code to find "12" in column D (just using if/then value like "*12*"), but I have no idea how to identify the first cell with a $ above that in column A. Any ideas?
*****
Edit so it doesn't get bumped after 3 days, but in case you look at this again: thank you.
Bookmarks