Forum

Hi Steven, This sounds like a job for Power Query - have you tried it? Please supply sample data files and an example of your expected result...

Hi Rutuja, You haven't supplied a workbook with sample data so I'm guessing at what you are working with. You could try this Sub FindWord() ...

Hi, What you're asking isn't clear. Please supply a sample workbook and an an example of what you expect as a solution. Regards Phil

Hi Bandi, VBA isn't enabled by default as this poses a security risk. If it is enabled it should not be. So you can't do what you ask because 9...

Hi Jacek, After adding the column, if you drag it into position so it's the first column, a new step is created which will do this every time. R...

Hi Jacek, Group the rows and aggregate the Number column by Minimum. This in itself will tell you if 1 exists, but if you want to create another c...

Hi Sebastien, The quickest solution would be to use the SUBSTITUTE function =SUBSTITUTE(SUBSTITUTE(H3," ", " / "),"License","O365 ") See atta...

Hi Jason, See attached file for solution using this code if [#"Difference in Days - Paid Date vs Last Scan Date"] >= 1 and [#"Difference in D...

no worries

Hi Robert, Yes there are a few ways to do this in PQ, check these posts out Easily Compare Multiple Tables in Power Query • My Online Training H...

Hi, When you open a workbook containing macros you should get a default warning towards the top of the screen (under the Ribbon) asking you if you ...

Hi Nelly, Yes, you trap the error and log the filename as you see fit, then continue on with the next file. See these posts for instructions on er...

Hi Scoti, This post describes how to create a stopwatch and is controlled by the value in a cell. Modifying the code should do what you want. T...

Hi, You haven't supplied any data so it's hard to understand what your data looks like. Please, always supply sample data and show your expecte...