I need a user defined function (UDF) that:
1. will take instructions from other cells on the operations it needs to apply
2. will apply these operations across a row in which the UDF is entered
Please note, I have minimal experience with VBA and would like the user defined function to be well commented/documented so I can try to understand it.
As it is difficult to explain my request in word, I have attached an excel file with example data and tables to illustrate exactly how I want this function to operate. I will also need instructions on how to use this UDF in any workbook I choose (i.e. transfer it across workbooks and sites, as needed).
I have posted a video to youtube that attempts to describe how I want this to function within the attached workbook. I apologise that the video is not of the highest quality, but I hope it is clear enough