Oops, I am sorry I just knew about the accept from your message this morning. For some reason I have not received an email notification about it at the time. My apologies. I will be working on it right away.
Ok, here are the instructions for copying the macro from one workbook to another
1- Close all Excel workbooks and Excel programs. 2 - Open the file that I sent you.3 - Press the keys ALT + F11 to open the Visual Basic Editor 4 - Copy the macro code by selecting all the code lines and copying it5 - Close this file6 - Open your own workbook7 - Press the keys ALT + F11 to open the Visual Basic Editor 8 - Press the keys ALT + I to activate the Insert menu9 - Press M to insert a Standard Module10- Paste the code11- Make any cusXXXXX XXXXXes to the macro if needed at this time12- Press the keys ALT+Q to exit the Editor, and return to Excel13- Save your excel file..
Hope this helps. Let me know if you have any questions
Hi again Randal.
Yes we can set up formulas to convert the case but I need you to send me the file again as the old file link has expired.
Ok, I created formulas in column C (yellow) which convert all items in Product column to the case you want. However since we cannot run macros on this file there is no way we can apply this to some cells and not to others (e.g. by selecting the cells as we did before), so the formulas convert all the cells, then it is up to you to delete the formulas from the cells that you do not wish to change the case of
Here is the file
Hope this helps