Oct 23 2020
06:23 AM
- last edited on
Feb 01 2023
11:01 AM
by
TechCommunityAP
Oct 23 2020
06:23 AM
- last edited on
Feb 01 2023
11:01 AM
by
TechCommunityAP
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.
many thanks
Steve