How to transfer the data from one excel sheet

Closed
Report
Posts
1
Registration date
Tuesday April 7, 2015
Status
Member
Last seen
April 7, 2015
-
Hi,

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.