I know ctrl h can find a single word or value and replace it on all sheets. Is there a way to take a list of value; vertical, and replace them with another list of various values?
I know ctrl h can find a single word or value and replace it on all sheets. Is there a way to take a list of value; vertical, and replace them with another list of various values?
Check out the file attached. You can use the VBA code, assign it a shortCut key and probably do what you need to do. (I was confused by Variatus - 'No then Yes use VBA'. Good luck