Hi All,

I have orders data in Sheet 1, and it needs to be segregated into different sheets based on the segment in Column H (e.g., Consumer, Corporate, or Home Office). Further data analysis will be conducted in the individual sheets by adding additional columns. All data should appear in the respective individual sheets. Since the data in Sheet 1 is dynamic, any changes made there should automatically reflect in the respective sheets. What would be the best approach to achieve this without using a macro?

​Hi All,I have orders data in Sheet 1, and it needs to be segregated into different sheets based on the segment in Column H (e.g., Consumer, Corporate, or Home Office). Further data analysis will be conducted in the individual sheets by adding additional columns. All data should appear in the respective individual sheets. Since the data in Sheet 1 is dynamic, any changes made there should automatically reflect in the respective sheets. What would be the best approach to achieve this without using a macro?  Read More

​