The only way is with VBA. It's not difficult if that is what you want to do.If what column (s) are changed, do you want the values (in which columns) cleared?
The only way is with VBA. It's not difficult if that is what you want to do.If what column (s) are changed, do you want the values (in which columns) cleared?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi ChemistB,
Thanks for getting back to me so quickly.
If the column KEEP THIS TYPE OR CHANGE (H68 for example) is changed, I would like to clear the value in ORDER THIS TYPE OF HOLDER (I68).
If the column CURRENT PINPAD HOLDER TYPE (G68) is changed, I would like to clear both H68 and I68.
I have no experience with VBA, so I wouldn't even know where to start.
Thanks again!
Kim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks