Hello,
I'd like to create a button that does the following:
- Button is located in every city sheet (button module) and uses cell A1 as reference (i.e., 'LA' sheet uses Los Angeles)
- Click creates search in 'Internships' for rows with "A1-Approved" in column H (i.e. for LA again, it would be Los Angeles-Approved. This is so I can use it on every sheet in my workbook without creating separate modules)
- Creates a delimited comma list of all approved internships (column B of every approved row) in cell G6 of the city sheet
Thank you!
Bookmarks