Dynamic Name Range ~ Define Automatically

do your calculations in the Raw Data sheet instead, then it will auto populate the pivot. I'm guessing that the analysis formulas don't change right?

there are only 3 columns with calculable numbers, are there any other columns in your real workbook?

Dear Scott.s.fower,

Thanks for your Immediate Response; yes, there are many other columns available in my Working File and I will not be able do the calculation from “Raw Data” Itself.

One of the Reasons behind that is, there are only 82 Items which is getting used across four different products. But since the items are repeated in each product, I will not be able to allocate my Inventory, Receipts, Etc., for all repeated lines. If I do so, my calculation will be wrong.

Hence, I made the Pivot of this, So that there will not be any duplicate Text in any Columns.

Consequently, I would like to set up a Dynamic Named Ranges which will help me & make my analysis easier.

Hope, I clarified your concern…

Thanks & Regards,
Rajeshkumar R

Hello Friends,

Kindly note Dynamic Naming Starting Reference Cell always remains same only…

Sorry, I would have told this in my first Thread itself.

Any Possible Suggestion or Alternate way of getting this done is Really Appreciated!!!!

Thanks for your Patience and Support!

Thanks & Regards,
Rajeshkumar R

here you go... if the pivot table columns are changed the macro will no longer work

Please Login or Register  to view this content.

if someone is really adventurous they can help you with a search function that will find the header and make the named ranges based off of that so you could move columns around and still get the named ranges

Hi,

Thanks a lot, It works perfect!!!

Regards,
Rajeshkumar R

Hi Mr. MarvinP,

Yes, I acknowledge your file…

Thanks you So Much!!!!

Regards,
Rajeshkumar R