Hey all...
Take a look at the attached spreadsheet. I'm trying to find a way to search for a value in a specific range and then paste information into the cells below that location. But there are two levels. The user will enter the information that they want to search for in cells Q22 and Q23. Then the macro will search for those values in the specified ranges and then past information in the corresponding column below the found values. For example, if the user enters "Headliner" and "Med.", then the macro needs to store the cell location AG2. Then the rest of the code that I will add will paste cell information into that column which will come from the rest of the spreadsheet. I'll work that out, and I was able to store the first location (AD1 for headliner). But, I can't figure out how to capture the "high" column under headliner. Can someone help me?
Thanks.
Bookmarks