Forum

Sholtan, I can't figure out what files are for input,which ones are for output. You've shown an image of 'correct output' but which file is this...

Sholtan, Please attach the workbook with the VBA in it. Even if you paste code we have to copy it, create a workbook, paste it in, save it etc etc...

Hi Janai, The code you've supplied doesn't seem to tie in with the data you provided e.g. the code refers to Range("C10"), Range("D10") and Range("...

Hi Maurizio, You can use Application.FileDialog(msoFileDialogFilePicker) to let the user choose the attachment. I've unmerged the cells on the s...

no worries Maurizio.

Between us we came up with 5 solutions. Pretty good. 🙂

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...