I have the following vba code that works to a degree; however, I want to make a few changes.
1. Instead of the logic looking for any rows with data in column 37, I want it to find specific values (e.g. "Apple") instead.
2. Paste the information into the new sheet without any formatting...