Forum

Hi @kris78 I know you said you've found the info you needed but I'll elaborate for anyone else reading this. If you just want the best Excel skil...

@sathish21 Our courses are recorded video, you watch them at your own pace. But we do of course provide support for you. You can ask questions vi...

@webbers can you please supply your file (or a mock up with dummy data) so we don't have to recreate everything

Hi @cribbage That image doesn't seem to match what you describe or what your initial description was. If you are taking data from Row 8 of the mas...

Here is Andrew's file

Here is Vestal's file

Hi @cribbage I'm really confused about what you are trying to do. You want the whole of Row 8 from the 2024 NQ H1 MASTER sheet in cell A1 on the ...

Here's the OP's file

@jenoye Sorry, your post was stuck in moderation but as you'd attached it to a non-related post I missed it. Please start new topics when posting...

Hi @cribbage Don't use merged cells - ever! Unmerge the cells and attach a copy of your file, much easier to help when we have the file. Regard...

Hi John, Yes you can do this. Columns in Power Query are lists so you can access items in that column/list using an index (starting at 0 for the fi...

Initial post updated with OP message and file

no worries 🙂

Hi Sherry, I'd try using the Command Prompt rather than VBA for this. See if del "C:UsersbarneshOneDrive - HIIDocumentsHIITrainingOnboarding* - ...

Hi KS, No worries. Yes using Table.Buffer and List.Buffer are the way I'd do it too, it makes PQ much faster. Regards Phil