Forum Discussion
Excel table mirroring both ways
In general, the "flow" of data is in one direction. There's the raw or input data, and then the processed or output data. It's a LOT easier to retain integrity of the data by managing it in only one place; said another way, it's a lot more likely that data will get messed up if we're managing it in multiple points in the process of acquiring, storing, using, updating. I'm trying to picture circumstances where that would change, in particular what it is that you're facing that would make it desirable to go two ways.
Is it not possible, for example, to use the filtering ability on what you're calling the "original" table, to isolate the row or rows needing adjustment, and do the editing there. Then just have an output sheet (sometimes called a "dashboard") that retrieves the portions of the whole (from "original") that you want to review?
In general, the "flow" of data is in one direction. There's the raw or input data, and then the processed or output data. It's a LOT easier to retain integrity of the data by managing it in only one place; said another way, it's a lot more likely that data will get messed up if we're managing it in multiple points in the process of acquiring, storing, using, updating. I'm trying to picture circumstances where that would change, in particular what it is that you're facing that would make it desirable to go two ways.
Is it not possible, for example, to use the filtering ability on what you're calling the "original" table, to isolate the row or rows needing adjustment, and do the editing there. Then just have an output sheet (sometimes called a "dashboard") that retrieves the portions of the whole (from "original") that you want to review?
I guess I'll have to use the filter option like you mentioned, it is probably the best way to go.
Thank you for the fast reply. 🙂