Forum Discussion
Obtain data from a cell with lots of paragraphs
If you want the function to be available in all workbooks, store it in a module in an add-in or in your personal macro workbook PERSONAL.XLSB.
Is the attached version better?
If you want the function to be available in all workbooks, store it in a module in an add-in or in your personal macro workbook PERSONAL.XLSB.
Is the attached version better?
OMG OMG OMG OMG!!!!! This is exactly what I needed!!!!
However, I'm facing a problem on how to save what you've made to all my excel workbooks from now on.
I copied my columns to your text(dot)xslm files. And it works perfectly.
Now how do I add this to my other workbooks.
Tried googling the procedure, and I exported the module, and tried importing it. didn't work.
and tried random stuff on my other workbooks. didn't work either.
unsure what keywords to google to get the answer. I've googled "how to save a custom excel function to my other workbooks" and tried those stuff. perhaps I'm doing the procedure wrong.
THANK YOU SO MUCH!!!! this helps me so immensely.