Create Multiple Dynamic Named Ranges with a Macro

Howdy,

I am stumped while trying to create multiple unique dynamic ranges on a report I am working on. I need a macro that will create a range for all the shipments that a certain sales name has.

Here is an example for the first sales name. Which is currently called Sales_Shipments_1

=OFFSET(Details!$B$1,Details!L3-1,0):OFFSET(Details!$B$1,Details!M3-1,0)

I would just code all of these manually but Every time I update this report a new number of shipments and unique sales names will come up. Please see attachement for more details.



Any help would be greatly appreciated.

Best Regards

Hi bennank

The code in the attached will update a unique list of SALES_NAME every time it's run (see Module 2, Summary). It also fills the Table with desired output. Let me know of issues.