I have a list of accounts that has charges made against the various counts on a daily basis. Each account has a unique 7 digit project code that is associated with it, listed on the master log/ list of charges.
On a seperate reference worksheet, I have a named range called "LU_PROJECT."
I am attempting to assemble a tool that on a new now third worksheet, would take a snapshot of the balance in each account/project code.
How can I assemble a formula/macro that will list out the unique non-repeating values of the project codes in the named range daily?
On a seperate reference worksheet, I have a named range called "LU_PROJECT."
I am attempting to assemble a tool that on a new now third worksheet, would take a snapshot of the balance in each account/project code.
How can I assemble a formula/macro that will list out the unique non-repeating values of the project codes in the named range daily?
