Forum

For you? Anything : ) The first link is looking for a file that is the copy of the file I'm opening, a copy I created at one point, but never r...

The least I could do.

BTW, I created a PQ to handle converting the Embed path to the path that can be used (use the attached file as a sample): let Source = Excel.Curren...

Hi, I found a solution: Get data from OneDrive Personal files with Power Query (exceloffthegrid.com) Regards, Ayal Telem.

Hi, Some of the problem I was able to solve, as the headers row-splitting was coming from the original file, but the width I cannot see where it ge...

Hi Mynda, Thanks very much for clarifying this. Regards. Ayal Telem

Hi Mynda and Hans, Plots are agricultural sections or areas where you grow stuff. My Excel version is 365. I have attached 2 files: "Dusting ...

Hi Riny, I thought about such a solution. It is strange to me that MS didn't came up with a more elegant solution. Thank you very much, ...

Replying to myself: The only way it can be done is creating a sheet in each workbook that looks at the list-of-values workbook. Half elegant. ...

Hi Mynda, That's what I was looking for. I can say with pretty high confidence: you're great : ) Regards, Ayal Telem

Hi Riny, Few more useful replies from you, and you can start charging me... I remember I searched in my profile and couldn't find it, and also I...

Hi Mynda and Riny, Sorry to forget to add the attachment - I added it in this reply. Anyway Mynda got the problem correctly, and the video she p...

Hi Riny, First, thanks for taking the time to help me - highly appreciated. I looked at you solution, and I vaguely understand the solution. As ...

Dear Mynda, Basically, column I & J each contains rows that corresponds to parallel row in the other column, e.g.: on row 4 "AEGIS" & "5550...

Hi Mynda, I have no problem sharing, but it's in Hebrew, so it will be too hustle for you. Second, I have 2 share 2 files, since the issue ...