GRRR.. I actually found another way around it after this but thanks for your help anyway 🙂
@Mynda I have Office 365 - version 1808 but another Excel colleague has 1901 and he really noticed the improvements. @Velouria - I thought of that as ...
Neither can I see a particular use for it either, but she asked me to help 🙂 So thank you as always 🙂
I tried answering in this box but it wouldn't let me so I am attaching a file with the data and a file with the various explanations..thanks again 🙂
DOH! moment! Here it is. :-(. After all, it's not like I haven't done this before... 🙂
Yes, so OK, at least I know I am on track...:-) So what function should I use for that and what syntax? Thanks 🙂
Ah, perfect. Knew I was missing something obvious 🙂 Anne
Well, the person has 12 files - one for each month - just the way her Payroll is set up and wants to have the same set up for 2019. Think I'm going to...
@Anders Sehlstedt and @Velouria - thank you both. So I have got as far as both the steps you have outlined. Just a couple of questions about this. I'v...