How to transfer the data from one excel sheet

manishkjain1976 Posts 1 Registration date Tuesday April 7, 2015 Status Member Last seen April 7, 2015 - Apr 7, 2015 at 01:50 AM

I want to transfer the data from one sheet to multiple sheets based on one specific one cell text. e.g. i have customer details for sales and their status in another cell. I want to shift the data based on status change to another sheet.

Please help me with the possible solution.