Paul_Hossler
03-03-2009, 09:40 AM
I have a pricing sheet that is based on PartNumber, but may also be based on Quantity and/or Date ranges, as well as neither.
I have a UDF that seems to work well (so far: pray2: ), but I can't figure out the worksheet formula equivalent. I need to provide macro-less worksheets to some users.
There is a macro that runs to prepare the source data for the UDF which runs as part of an over all process. It does some checks and adds sentinal values for ending quantities and dates. What I'll do is use VBA to include the .Formula in the copy of the worksheets for the macro-less workbooks.
Attached WB has sample data of the 4 different cases, expected results, and the UDF output.
Thanks
Paul
I have a UDF that seems to work well (so far: pray2: ), but I can't figure out the worksheet formula equivalent. I need to provide macro-less worksheets to some users.
There is a macro that runs to prepare the source data for the UDF which runs as part of an over all process. It does some checks and adds sentinal values for ending quantities and dates. What I'll do is use VBA to include the .Formula in the copy of the worksheets for the macro-less workbooks.
Attached WB has sample data of the 4 different cases, expected results, and the UDF output.
Thanks
Paul