I've got a sheet where I'm keeping track of the status of certain items for a particular customer, and another sheet where those items are stored as they're worked on across all customers. Would it be possible for me to take the status column from the internal board across all customers and have it update automagically in the customer specific sheet?
So like, say I have a column called "Item Status" and "Item Number" on both sheets. On the internal sheet if someone changes the status from say "Pending" to "In progress" for item number "1", is there a formula I could use on the customer specific sheet to change item 1's "Item Status" automatically from "Pending" to "In progress"?
As it is I'm having to manually swap back and forth to ensure the two sheets reflect accurate information and that's a lot of overhead.
