Hi all,
I don't know if this is possible, but I would like to auto populate a dynamic ranged based on a given criteria in another table. I have the dynamic range built and it is working, but I don't know how to auto populate it. I know that I could use a single cell array formula and copy it down but I would like to avoid that approach.
I have a worksheet that serves as a master list off all equipment. I need a formula that will populate a named range, called UnitProjectionRange, with all Unit #'s that are set to Calculate for Depreciation with a "YES" value in the master list. Please see attached example. Thanks.
Bookmarks