albe.btz
08-23-2017, 06:07 AM
Hi forum,
i've another exciting question for you (and my desperation to heal).
So, in the benchmark model attached (part of it due to size limits)
20153
the file has been completely ligthened of data an features to fit the forum's limit but you should be able to get all the information.
a bit of background: whilst Expanded periods, and GANNT are sheets regenerated everytime i run a macro "Variations" works as a database to record all the fare variations.
it has to take some lines from Expanded periods and store them at the bottom of the sheet.
what I am unable to do is to implement a module that makes it happen: this module has to find and select the specific row for different seasonality (LOW,SHO,BUS) for each CXR (QF,EY,SQ,MH,CX,BA,QR) for each destination (SYD, MEL, AKL).
Then it has to copy and paste it a the bottom of VARIATIONS inserting the date when the module has ran (this to build the history of variations).
HELP MEE PLEASSEEEEEEE : pray2:: pray2:: pray2:
i've another exciting question for you (and my desperation to heal).
So, in the benchmark model attached (part of it due to size limits)
20153
the file has been completely ligthened of data an features to fit the forum's limit but you should be able to get all the information.
a bit of background: whilst Expanded periods, and GANNT are sheets regenerated everytime i run a macro "Variations" works as a database to record all the fare variations.
it has to take some lines from Expanded periods and store them at the bottom of the sheet.
what I am unable to do is to implement a module that makes it happen: this module has to find and select the specific row for different seasonality (LOW,SHO,BUS) for each CXR (QF,EY,SQ,MH,CX,BA,QR) for each destination (SYD, MEL, AKL).
Then it has to copy and paste it a the bottom of VARIATIONS inserting the date when the module has ran (this to build the history of variations).
HELP MEE PLEASSEEEEEEE : pray2:: pray2:: pray2: