I'm trying to find an easier way to copy a bunch of information. First, I need to determine any numbers in row L (YTD Expenses) that are negative. Second, I need to determine what Grant those negatives are on (Row C, Grant). I then need to copy ALL the rows that contain that grant number to a different tab. I have been doing this manually but surely there is a better method.
Any help is greatly appreciated.
Thanks in advance!!