Forum

Hi Deepak, I can't really test this without Foxit. But why not just convert the whole PDF then delete the first page in Word? See attached. ...

Hi David, You can use FileSystemObject to create folders. This post has some code you can adapt Regards Phil

Hi, The total for Plant where Material is 1001 should be 36004, and where Material is 1002 it should be 27000? You haven't said where you get th...

Hi Scott, Welcome, please refer to forum rules Please start your own topic rather than tag onto the end of an existing thread. Please suppl...

Hi Deepak, Please review the forum rules and guidelines When you have a new question please start a new topic, don't post onto the end of an e...

Hi Zaki, You can't conditionally format a chart. You'd need to create another series for data points that go beyond a certain value and plot those...

Hi Frans, If you've deleted some data from the source, that data can still be displayed unless you tell the PT / Slicer not to display it, even if ...

You're welcome 🙂

Hi Wansley, You have code in the workbook which is not mine: Private Sub Workbook_Open() If GetCodeSetting("CodeSetting") = False Then Exi...

Hi David, I'm not sure that the data is misleading, the values are what they are. When your wife asks for the numbers to be 'closer together' what ...

So if you are overwriting the data every time you take a report from SAP, there is no way to know what emails have been sent, with the current code. ...

Hi JP, Power Query isn't really the tool for this. This is an optimization problem you should do in Excel. It's not clear if this is a one off ...

Hi Mido, The code will send an email when the value in Col E is >= 180. When an email is sent the code will enter the date the email was sent...