I have a database where rows will be added at regular intervals. I have created a dynamic named range, called Data. How do I change my functions to reflect the changes in the database. Here is the function which I am now using.
Sorry, but I don't understand how the function works. Does the -- (or *)refer to the dynamic named range that I've located in another worksheet? Also, do the mydates and myproduct syntax refer to the column names?