- Joined
- Jun 2, 2006
- Messages
- 5,386
- Likes received
- 508
- Thanks received
- 221
- Location
- Colchester
If it's a one-off and you suspect it's just excel crashing, I'd try doing the same
on Libreoffice or openoffice to see if they work any better.
Have tried a couple of times and get the same result - when there was less data it would take around 45 minutes to enter the subtotals so am pretty sure it's just shear volume combined with nested Vlookup functions which I understand take up a lot of processing power




Quite happy to record macro's but not really any good at writing them! Can kind of understand what you've written - will this still work if the number of rows vary? I can't give a definitive end point