MG
The Classic Marque

Its funny how some things you never forget, but others drift off. I did Exel advanced years ago and used it in work daily at many levels but not done so for about 15 years and cant remember the more complex things now.

Trev

Maybe offspring are best! I used to teach Excel, mainly at BTEC level, but didn't go much beyond nested IF's and lookup tables. I don't think I used macros (although I did with Access database). I've forgotten a lot of the detail though, as one does. Just use it now to compare energy tariffs. Sorry can't be of more help.

I have used pivot tables before, but its 20 years ago and not one of the tasks I instructed my brain to hang on to 'just in case!
My other option is to get offspring to advise. I'm pretty sure youngest must do this stuff on finance spreadsheets on a daily basis.

The cars had its first introduction to the Curborough Sprint Course today and after being sat outside on the trailer for a couple of days in the cold and rain, it thankfully burst into life at first attempt with the help of the carb mixture enrichment device and later performed really well.

Still a few jobs to sort before the sprint season starts but will check the idle mixture screws but n...

More sophisticated than I've ever used excel Guy.

This?

https://dev.toadforsqlserver.com/webhelp/content/Automation/Tutorials/Automate_Excel_Pivot_Reports.htm

Probably worth checking that the idle mixture screws are free and the tip hasn't jammed and broken off, not an uncommon occurrence AIUI as the needles are quite a small diameter and a fine taper. A mate tracked down an issue with his 45 DCOE to one or both having broken off so they were replaced after the broken bit was removed from the carb body.

I'm always reminded of the famous Titus Oates 'Archives' quote "I'm just going out and I may be some time"

David, my apologies. You use proper languages then! 😉

No, don't ask me I can't stand VB/VBA, I'm a C C++ guy. Spreadsheets I use rarely and they're fairly basic, I can usually achieve what I want by other means.

Yes, that's what I used to identify which rows to hide, and to enter the flag 'Hide" into the first column. That works fine. It's the activation that I need to get it to do.
I've an idea I may need to explore pivot table and get it to run a report.