Forum Discussion
Excel data segregation
Hi m_tarler thanks for this, but my requirement is the data should be dynamically changeable. if i make any updates or changes to the data in orders sheet related to segregated data sheets they also should be updated. when used the sample which you have attached when i made any change (delete a cell or overwrite) it is throwing as #NAME?. could you please help on this.
if you are getting a #NAME? that means excel isn't recognizing something in the formula.
a) do you have excel365? if you type =FILT do you see an autocomplete box with the option for FILTER? I suspect this is your issue. What version of Excel are you using?
b) when you edit or delete a cell that shouldn't be a problem as long as you didn't delete the Table. So in that example I referenced a 'named table' in particular "Orders" was defined as a table and then Orders[Segment] is the column of data in that Orders table with the heading 'Segment'. Even if you edit the column header from Segment to something else Excel should recognize that but if you delete the column Segment then Excel will throw an error as that column no longer exists (but probably not the #NAME? error you mentioned)