Populate Data Using Given Variables, NON-VBA

[chaserracer83]

Hello there, I'm not sure if there is a way to do this, but I wanted to ask anyways...

I have a data table I would like to populate automatically using a combination of variables and constraints. Basically I want a dynamic set of data that provides the following:

• Data Vintage_Month and As_Of_Month based on an Input_Date
• Contains a unique row for every combination of; As_Of_Month (starting with vintage month + 80), Vintage_Month (all months 5 years prior and 5 years after Input_Date), Product, Grade
• Exclude any As_Of_Month that is 5 years greater than the Input_Date

I would like to avoid any VBA. In causes too many complications in my company's security environment.

If any one has any suggestions on this they would be very appreciated.

Thank you,
Chase

 

[barjoman]

Is PowerQuery an option? If I understand your requirement correctly, this is not too difficult to implement if PQ is an option.