See attached. Need a macro that provides the following:
In Column A in Sheet1, I need output of ONLY the Variables from "Variable List" in Sheet2 that meet this criteria:
Milestone1 and Milestone 2 are dates on Sheet2 in Columns C and D that correspond with a variable in Column A. The data in the rows is row-specific. In a particular row, if Milestone2 - Milestone 1 < 30 days then print the Variable name in the row to Column A of Sheet 1. If Milestone2 - Milestone 1 > than 30 days, then DO NOT print the corresponding variable in Sheet1. The output in Column A if Sheet1 should not contain empty rows.
If you have questions, please do not hesitate to ask.
I need a macro with a push button on Sheet1 that will run the macro - not if statements embedded into the Excel sheet.