Hello,

I am currently creating a spreadsheet for following up on leads.

I have a main data file that feeds into a spreadsheet. I need to be able to move 3 different text values to different tabs.

Column B will have; Won, Lost, Cancelled and based on these I need to move those 3 separate rows to 3 separate tabs, currently I can only move one without messing the code.

Capture.PNG

Thank you.