This is all quite complex - especially the code!
I've got a few questions first, because the code could perhaps be much shorter and simpler.
1. Do you have a version of Excel where some of the formulae (eg FREQUENCY) automatically spill into adjacent cells when committed to the sheet?
2. On Sheet1 of the attached, in cell J7 to J12 is a formula which gives the same results as yours in E2:E6. It's one line of code to place that formula there and one more line to convert that range to plain values. Could you work with that?
3. On Sheet6 at cell D6 there's a pivot table - it wouldn't take many lines of code to adjust the source data for that pivot and to adjust the grouping. Could you work with that?
4. What version of Excel are you using?
5. Is it a standalone desktop version or a subscription version.
Last edited by p45cal; 08-29-2020 at 03:45 AM.
|