Forum Discussion
Excel data segregation
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...
Hi HansVogelaar
thanks for this but my requirement is when ever i update or make any changes in the data in the main sheet(Orders) it should automatically reflect in the segregated sheet. if i use the attached version when ever i update the main sheet(Orders) i was getting as #NAME in the other sheet. could you please help on this?
Which version of Excel do you have? FILTER works in Excel in Microsoft 365, and in Office 2021 and 2024 (and in the online/browser version as well).
