Hi
I'm looking for a formula that can find a given order number on the attached and then change the order status in the same row from Open to Closed.
Hi
I'm looking for a formula that can find a given order number on the attached and then change the order status in the same row from Open to Closed.
To change a cell with text in it you will need VBA - shall I move the thread for you?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Appreciate it, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks