I have read numerous articles about this and none have really solved my issue. I decided to post my own specific question.
I have an excel workbook with a sheet titled "SF Performance" It has numerous columns and I would like to have all the data in each column for each row copied over to a second sheet titled "SF Performance High" when the one column (column L titled "Spend Level") = high.
That's it. How can I accomplish this. SF Performance sheet will have data added on a monthly basis so if data is entered and meets the "high" requirement I need it to automatically copy over to the SF Performance High sheet.