T Tareen New Member Dec 29, 2012 #1 Dear All, I have a very complex and long formula in WS1, is there a way I can save this formula using Name or macro and use in WS2.
Dear All, I have a very complex and long formula in WS1, is there a way I can save this formula using Name or macro and use in WS2.
Hui Excel Ninja Staff member Dec 29, 2012 #2 Tareen You could write a UDF to replicate your formula then store that in a Personal.xls/x file Then the UDF will be available to all workbooks on your pc
Tareen You could write a UDF to replicate your formula then store that in a Personal.xls/x file Then the UDF will be available to all workbooks on your pc
T Tareen New Member Dec 29, 2012 #4 I am a new xl user, so if possible pls suggest a link where i can get some tips on UDF. I tried but failed.
I am a new xl user, so if possible pls suggest a link where i can get some tips on UDF. I tried but failed.
bobhc Excel Ninja Dec 29, 2012 #5 Good day Tareen The links below should help you. http://blog.mclaughlinsoftware.com/2010/05/26/excel-udf-tutorial/ http://www.wikihow.com/Create-a-User-Defined-Function-in-Microsoft-Excel
Good day Tareen The links below should help you. http://blog.mclaughlinsoftware.com/2010/05/26/excel-udf-tutorial/ http://www.wikihow.com/Create-a-User-Defined-Function-in-Microsoft-Excel
