Forum

I am not familiar with your dat files structure which is why I need to see examples. Even with the data you supplied above it's not clear what the...

Hi Blue, I'd be looking to use Power Query for this. I'd need to see some examples of your files before I could offer any more. Regards Phil

Hi Ivica, We'll need to see some of these DAT files to understand how the data inside them is structured. Can you please supply some. Do you wa...

Hi Jatin, The code here loops recursively through all Outlook folders Regards Phil

Hi, If your data starts in A1 on both sheets then you can make use of implicit intersection and the formula =INDEX(Source[[Column2]:[Column4]...

Hi Larry, This code will do what you want. It uses FillDown to fill an empty cell with the value above it Sub FillDown() Dim i As L...

Hi Stefano, Try the attached file. regards Phil

Hi Larry, You can use something like this Sub copystuff() Dim i As Long i = 0 While Range("A1").Offset(i, 0).Value &l...

Hi Marsil, It's not exactly clear to me what you want to do. When I run the macro, I should change below cell count. so if there ability to run ...

Hi, The attached file will create a PDF for each row, but it is just saving the ActiveSheet as per your code. Is this what you want? Regards ...

No worries Alan 🙂

Hi FS, Let's use smaller numbers, all those 0000 are hurting my eyes 🙂 If we start with 10 and it increases to 11 then the change is +1. The %...

Hi FS, It depends on the percentage of which number you are calculating for. Your formula is (100000 - 110000) / 110000 Which is equal to 0....

Hi Alan, Yes you can add a file as your data source after you've created the app, but it may (will) require reconfiguring your app. I don't know...

Hi Lea, This is controlled by your Region settings in Control Panel. Your Windows may be set to English but it might be set to English (United S...