|Hi guys, |
I've browsed loads of previous questions to attempt to aid me in this but none have seemed to help.
I am a complete newbie with VB so bear with me.
I have a workbook with a worksheet called "Pipeline" in which users will type in to, I would like to assign a macro to a button that when pressed would look to column "O" and if the text says "45%" then cut that entire row and paste it into the next available row in worksheet "Prospect" (which is already created). I would also need to create similar conditions to cut rows into other worksheets based on the data in column "O" but i'm sure i could figure that out from the first question.
Any help is greatly appreciated, been stuck on this one for a few days now. (I am rubbish with excel)
Thanks a lot