Excel Macro Variable Named Ranges

Copper Contributor

Hi, I'm new here and haven't found a thread quite like this one, so I hope I can get some help or be pointed in the general direction of where to go.

 

I am trying to create a macro to add named ranges based on a change in a cell value and am really struggling to perform this.

 

The data I'm working on is from an export from d365 F & O so the data is variable in quantity each time, the data I also has doesn't have a primary key so I've added a formula which gives me the value in column a based on a change in a different column. I'd like to auto name range as detailed below and then be able to use those numbers to return results based on formulas utilising returns from a pivot table.

excel macro required.JPG

 

many thanks

 

Steve

0 Replies