Forum

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

Hi KS, To ignore case in the TextTable you can make the text and the words you're searching for all the same case by using either Text.Lower or Tex...

HI, No file attached. After selecting the file, click Start Upload. Phil

Hi, Your criteria are too vague. Please provide sample data and examples of the results you want. Regards Phil