by MarkRussell » Mon Aug 17, 2020 11:13 am
Hi,
You can load all of the markets into a Quick Pick List and then open all the markets as a Coupon View by right clicking on the list and selecting 'Open all markets in current tab'
Then link that to Excel where all the markets will be in one sheet underneath each other.
You can use the 'Minimum Coupon Rows' option when logging to Excel to space the markets evenly, e.g. use 30, first market will be at A1 next at A31 then A61 etc.
Today, for example, there are 34 markets which should be manageable in Excel but I would recommend looking at CPU and memory usage to ensure your set up can handle updating the required markets in Excel.
It was also depend on what you start doing in Excel in terms of functions / macros.
Regards,
Mark