I am new to vba and need help with a spreadsheet I am working on. I would like a macro that searches for the text string "FYI" in column "I" of the worksheet named "Data" and then copies all of the rows containing "FYI" and pastes them in the worksheet named "FYI" starting in A2. I have attached a spreadsheet as an example. I would like to be able to assign the macro to the button titled "FYI" and then I will change the macro to also find rows containing "PSA".
Thanks in advance.