Hello rook114, welcome to the board.
I don't think (off hand anyway) you'll be able to do this without the use of some vba.
Is that not an option at all? - or would some vba that executes automatically (without
having to be initiated by the user) be acceptable?
I had code in the sheet that performed what I wanted it to do, however with different users, the update worked on some, but not others. I can only suspect this is due to security settings. I don't know what else could have caused it.