Forum

Hi Stephen, Welcome aboard. Have you tried a pivot chart? Please supply your workbook and data. regards Phil

Hi Vinod, It's possible to install multiple versions of Office together, at least it used to be, but I've not done it with 2019. You can get iss...

Hi Paul, Because the IF statement will only evaluate until it finds a True condition you can use this, leaving out the AND's, by making your first ...

Hi Kat, You can't do that, it's what's called a circular reference. But if you explain what you are trying to do maybe there's another way. R...

Hi David, What exactly is the issue with getting your avatar photo uploaded? Phil

Hi, The syntax for SLOPE is =SLOPE(known_ys, known_xs) so you can just get the slope from, for example, sheet 44947 using =SLOPE('449447'!R2:R19,'...

Hi, Do you need the VBA to create the chart and trend line, or just get the x coefficient from the trend line on each sheet? Regards Phil

Hi Vinod, When I try to run your code it takes forever 'Contacting the server ...' and I eventually stopped the query. I wrote a new web query a...

Hi David, Yes, it'll keep going until it encounters a blank cell in Col B. Regards Phil

Hi Vinod, I can see that you are trying to get something from the NSE website but I don't know exactly what it is you are trying to do. Please g...

No worries Yousef. Maybe when we're all out of lockdown you can buy me a take-away 🙂 Don't be afraid to try some code modifications. You can alw...

Forgot to say that the code uses FSO (FileSystemObject) so in order for it to work you'll need to set a reference in the VBA Editor to the Microsoft S...

Hi David, Attached is some code that will create a folder structure based on the contents of the sheet. You can probably work out for yourself how ...

Hey Yousef, Did you try doing that yourself? 🙂 It only took another IF .. THEN statement - see attached. Regards Phil